Microsoft Office Excel Worksheet Xlsx File
Now that your spreadsheet is coming along nicely, you'll wantto save your work. To save your spreadsheet, do the following. Excel 2007 UsersIf you have Excel 2007, click the round Office button in the very top leftof Excel 2007. This one:When you click the Office button, you'll see the options listappear:In Excel 2007, you perform all the File operations by clickingthe round Office button. Clicking Close, for example, will close the currentExcel spreadsheet, but won't close down Excel itself. To close down Excel, clickthe '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 RecentDocuments heading.Click Save to see the following dialogue box appear:In the image above, we're saving our Excel spreadsheet to a NewFolder we've created in the Libraries Documents folder.
Microsoft Office Excel Worksheet 2007
Butyou can use the area on the left of the dialogue box to choose another locationto save your work.Notice the 'Save as Type' box below the file name. The type is aXLSX file, and this is new from Excel 2007. Whenever you see this ending,you know that it is an Excel file.Click the Save button when you're happy with the location Excel 2010 to 2013For Excel 2010 to 2013 users, click the Save icon in the top left of Excel(You can also click the File item just below the Save icon.):You'll then see this screen:You'll see three options: OneDrive (which used to be called SkyDrive), Computer,and Add a Place:The first option is OneDrive. This saves it to servers operated and controlledby Microsoft. This is very useful if you want to work on your Excel documentfrom other locations. For example, you may be working on a spreadsheet in youroffice.
Saving it to OneDrive means you'll also be able to open it when youget home from work. When you click the OneDrive option you'll be able to SignIn, Sign Up, or simply Learn More. We'll be saving to the Computer, though,so click this option.
Then click the Browse option. You'll then see the sameSave As dialogue box as above. Select a location to save your spreadsheet andthen click the Save button. Excel 2016For Excel 2016 users, Click the Save icon in the top left of Excel:(You can also click the File item just below the Save icon.)You'll then see this screen. (Make sure Save As is selected on the left):Under Save As, you can see four items: OneDrive, This PC, Add a Place, andBrowse.
The default is to save your work on your own computer (This PC), inthe My Documents folder:If you're happy to save your work in the My Documents folder, then type a namein the text box that says 'Enter file name here'. Click the Save buttonto the right and your file will saved as a XLSX spreadsheet.If you don't want to save your spreadsheet in the My Documents folder, clickthe More Options link. You'll then see the same Save As dialogue box as above,for 2007 users. You can also click the blue arrow, just to the left of My Documentsin the image above. You'll then see this:Navigate to an area on your computer by clicking an item on the list. Whenyou're happy with your chosen location, click the Save button.All Excel UsersIf you click the dropdown list, where it says Excel Workbook (.xlsx), youwill see that you can save your workbook in lots of different formats:So, if somebody has an older version of Excel, you can save it as an Excel97-2003 workbook. It will then be saved in the older XLS format.Remember to save you work on a regular basis, by clicking either the roundOffice button in Excel 2007 or the File menu/icon in Excel 2010 to 2016.
Thenclick the Save option. A quicker way is to just click the disk icon on the QuickAccess Toolbar in the top left of Excel (all versions):In the next part of this Excel course, you'll learn about currency options.
XLSX is the default format used by Microsoft Excel, versions 2007 and above. Microsoft Excel is compatible with multiple operating systems and it's currently one of the top applications for creating and editing spreadsheets.The XLSX format stores data in worksheets. Each worksheet has a grid of cells arranged in columns and rows. Cells can contain text and numbers of various fonts, colors and sizes. XLSX files may also include charts, pivot tables, graphs and mathematical functions. Microsoft Excel also features the Visual Basic macro programming language for applications.XLSX files are based on the Open XML format which stores all content in a zipped archive. The archive contains XML, RELS and media files (if applicable) stored in three separate folders named “docProps”, “xl” and 'rels'.
Files with the RELS extension dictate how the parts of the document connect to form a single file. The archive also includes a ContentTypes.xml file which describes the spreadsheet and separate XML files for each worksheet. This archived approach makes file content more accessible. For example images and text are stored individually within the archive.How to open XLSX filesThe contents of an XLSX file can be extracted individually by opening it with a data compression application (i.e. WinZip or WinRAR).
The XML files of an XLSX document can be opened with any basic text editor and any web browser.XLSX files can be opened with a large number of applications including online word processors. #1What a nasty little suprise. I buy a new PC with Vista and get Office 2007. Now when I send a friend a spread sheet with basic club info.; he can not open it.Vista windows explorer did not show me the.xlsx extnsion.
But good old CMD did. Grrr.Would be nice to have an option to save stuff with plain old.xls for my down rev friends who do not really need all the fancy do dah 'improvements'. Bill; there are a bunch of former friends of Bill out here who would pay for a version that offered retro as an option.With PCs having enough power to re-calc the interest on the national debt in a second; shouldn't be a big deal. It would help us out not to have to keep buying upgrades during the recession. #3I have a 32 gig flash drive with an Excel (Office 2007) file on it containing all my passwords and private information.After installing a new HDD and reinstalling MS Office 2007, I now find that I cannot open the Excel file and keep getting the message about the 'xlsx format etc'.I have tried everything I know to open it but nothing works! Is there any way I can get this wretched file to open or have I lost everything?Thing is it was all created on the 2007 Excel and nothing has changed except re-installation.