How to Title an Excel Spreadsheet

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

How to Create a Comma Delimited File from Excel

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

Excel UPC number formatting

How to Show Excel UPC Numbers in Full

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

How to Use the Excel New Sheet Shortcut

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

How to Make Negative Numbers Red in Excel 2013

The steps in this article are going to show you how to make negative numbers red in Excel. We are going to format cells with the “Number” format, then adjust a setting within that formatting option. Open your file in Excel. Select the cells for which you wish to make the negative numbers red. Right-click … Read more