How to save your work in Excel

<div dir="ltr" style="text-align: left;" trbidi="on"> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> Now that your spreadsheet is coming along nicely, you'll want to save your work. To save your spreadsheet, do the following.</div> <ul style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <li>If you have Excel 2007, click the round Office button in the very top left of Excel 2007. This one:</li> </ul> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="File Operations Button in Excel 2007" border="1" height="44" src="http://www.homeandlearn.co.uk/excel2007/images/FileButton.gif" width="43" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> When you click the Office button, you'll see the options list appear:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="The File Operations Dialogue Box" height="441" src="http://www.homeandlearn.co.uk/excel2007/images/FileDB.gif" width="433" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> The Office button used to be a file menu in previous versions of Excel. In Excel 2007, you perform all the File operations by clicking the round Office button. Clicking Close, for example, will close the current Excel spreadsheet, but won't close down Excel itself. To close down Excel, click the "Exit Excel" button in the bottom right of this dialogue box. If you want to open a recent Excel document, click its name under the Recent Documents heading.</div> <div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> For Excel 2010 and 2013 users, you don't have a round Office button. Click the <b>File</b> tab instead to see the menu options as above:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="The File menu in Excel 2010" height="427" src="http://www.homeandlearn.co.uk/excel2007/images/2010/File_Menu.gif" width="133" /></div> <div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> In Excel 2013, your spreadsheet will disappear when you click <b>File</b> and you'll see this screen:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img height="403" src="http://www.homeandlearn.co.uk/excel2007/images/2013/section1/save_as.gif" width="636" /></div> <div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> To save your work, click the Save option in all versions. Excel 2013 users will stay on the screen above.</div> <div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> Under <b>Save As</b> in Excel 2013, you'll see three options: <b>SkyDrive</b>, <b>Computer</b>, and <b>Add a Place</b>. The first option is <b>SkyDrive</b>. This saves it to servers operated and controlled by Microsoft. This is very useful if you want to work on your Excel document from other locations. For example, you may be working on a spreadsheet in your office. Saving it to SkyDrive means you'll also be able to open it when you get home from work. When you click the SkyDrive option you'll be able to Sign In, Sign Up, or simply Learn More. We'll be saving to the <b>Computer</b>, though, so click this option. Then click the <b>Browse</b> option:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img height="326" src="http://www.homeandlearn.co.uk/excel2007/images/2013/section1/save_as_browse.gif" width="489" /></div> <div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> You'll then see a dialogue box like this one: (Excel 2007 and 2010 users will see this straightaway.)</div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="Save As in Windows 7" height="463" src="http://www.homeandlearn.co.uk/excel2007/images/2010/Save_As_DB.gif" width="640" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> In the image above, we're saving our Excel spreadsheet to a <b>New Folder</b> we've created in the <b>Libraries > Documents</b> folder.</div> <div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> If you have Windows XP, you'll see this at the top of your dialogue box:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="The top of the Save As dialogue box" height="61" src="http://www.homeandlearn.co.uk/excel2007/images/FileSaveAsTop.gif" width="421" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <b>Save in</b> means "Where would you like to save your spreadsheet?" In the image above, we're saving it to a folder called <b>excel</b>.</div> <div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> Notice the blue down-pointing arrow on the <b>Save in</b> drop down list. Click the arrow to reveal more locations:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="Save locations" height="169" src="http://www.homeandlearn.co.uk/excel2007/images/FileSaveAsTop2.gif" width="227" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> Choose a new location from the list, if you prefer. The large white rectangle on the Save as dialogue box will then show you all the files already in the location.</div> <div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> When you're happy with your file location, type a name for your file in the area at the bottom of the dialogue box :</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="Type a name for your spreadsheet" border="1" height="52" src="http://www.homeandlearn.co.uk/excel2007/images/FileSaveAsBot.gif" width="366" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> Notice the "Save as Type" box below the file name. The type is a <b>XLSX</b> file, and this is new from Excel 2007. The old ending was XLS. Excel 2007 and 2010 can open older XLS files, but previous versions of Excel can't open XLSX files.)</div> <div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> Remember to save you work on a regular basis, by clicking either the round Office button in Excel 2007 or the File menu in Excel 2010/2013. Then click the <b>Save</b> option. A quicker way is to just click the disk icon on the Quick Access Toolbar in the top left of Excel (all versions):</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="Quick Save" border="1" height="25" src="http://www.homeandlearn.co.uk/excel2007/images/FileSaveAs2.gif" width="116" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <br /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> Coming up shortly is a Review, so that you can test your new knowledge of Excel. First though, you'll need to know about currency options.</div> </div>

How to save your work in Excel

Now that your spreadsheet is coming along nicely, you'll want to save your work. To save your spreadsheet, do the following. If you ...

Read more »