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
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
The steps in this guide will show you how to make the gridlines darker in Excel 2016. Click the File tab at the top-left of the window. Select the Options button at the bottom of the left column. Choose the Advanced tab. Scroll down to the Display options for this worksheet section, then click the … Read more
The steps in this article are going to show you how to remove a watermark in Microsoft Excel. This means the watermarks that are added to the background of the page, typically consisting of either a word or an image. Open your file in Excel. Select the Page Layouttab at the top of the window. Click … Read more
The steps in this article are going to show you how to format a blank Excel spreadsheet so that it will print, with gridlines. We will cover the steps briefly at the top of this guide, then we will continue further below with additional information and pictures for the steps. Open Excel and create a … Read more