Older versions of Microsoft Excel used to create files with a file type that ended in .xls. However, newer versions now use a file format that ends with .xlsx. Newer versions of Excel can open these older Excel file versions, but some older versions of Excel have trouble with the newer file format. Excel is … Read more
Most of the data that you enter into an Excel spreadsheet will typically go into the cells. But you can put other objects in a spreadsheet, such as a text box. You may be wondering how to delete a text box in Microsoft Excel if you don’t need it. Text boxes can be useful in … Read more
Giving a title to an Excel spreadsheet makes it much easier to identify the spreadsheet in the future if you need to view it or edit it. Use these steps to title an Excel spreadsheet. Open the file in Excel. Click the Page Layout tab at the top of the window. Click the small Page … Read more
While default files that you create in Microsoft Excel are going to be in the .xls or .xlsx file format, you have some other options. Use these steps to create a comma delimited file from Excel. Open Excel and create a new workbook. Enter the data into your cells. Click the File tab at the … Read more
The steps in this article are going to show you how to display Excel UPC numbers in full, as opposed to the scientific notation that it displays by default. This setting will only apply to each worksheet for which you make this formatting change. It doesn’t carry over to other spreadsheets or new spreadsheets that … Read more
The steps in this guide are going to show you how to use a keyboard shortcut to create a new worksheet in Microsoft Excel. An Excel workbook is the Excel file itself, while an Excel worksheet is a single spreadsheet within that workbook. You can switch between worksheets in Excel by clicking the file tabs … Read more