How to Center Horizontally in Excel Spreadsheets
When you print a spreadsheet in Microsoft Excel, it is going to be aligned to the left side of the page. But if you don’t… Continue Reading How to Center Horizontally in Excel Spreadsheets
Excel
How-to guides and tutorials about the Microsoft Excel spreadsheet application.
How to Enable Macros in Excel 365
The macro feature of Microsoft Excel gives you the ability to do some really powerful stuff. But it’s also potentially dangerous if someone sends you… Continue Reading How to Enable Macros in Excel 365
How to Use the Excel New Sheet Shortcut
Microsoft Excel has a lot of shortcuts built into the application that you can use when you want to accomplish a specific task. One particular… Continue Reading How to Use the Excel New Sheet Shortcut
How to Delete Sheets in Excel
The ability to add new worksheets to a workbook in Microsoft Excel makes it easy for you to organize the data into your spreadsheet in… Continue Reading How to Delete Sheets in Excel
How to Insert Picture in Excel Header
While you might have worked with headers in word-processing applications like Microsoft Word, many other applications let you customize headers, including Microsoft Excel. You can… Continue Reading How to Insert Picture in Excel Header
How to Remove Page 1 Watermark in Excel
Microsoft Excel has a lot of different ways that you can format and customize your data. Some of these options, however, are focused more on… Continue Reading How to Remove Page 1 Watermark in Excel
How to Make Gridlines Darker in Excel 2016
If you are having difficulty seeing the lines that separate the cells in your spreadsheet, then you might try to change the brightness on the… Continue Reading How to Make Gridlines Darker in Excel 2016
Where Did My Column Letters and Row Numbers Go in Excel for Office 365?
It’s fairly easy to take the row numbers and column letters for granted in Microsoft Excel. They are almost always visible when you are editing… Continue Reading Where Did My Column Letters and Row Numbers Go in Excel for Office 365?
How to Print Empty Gridlines in Excel (An Easy 5 Step Guide)
Microsoft Excel has a lot of uses, both at home and at work. One way that you can use it is when you’re writing a… Continue Reading How to Print Empty Gridlines in Excel (An Easy 5 Step Guide)
How to Fit All Columns on One Page in Excel 2013 (A Simple 6 Step Guide)
Have you ever printed an Excel worksheet that had one too many columns? You wind up with a single column printing on its own page.… Continue Reading How to Fit All Columns on One Page in Excel 2013 (A Simple 6 Step Guide)
How to Get the Excel 365 Developer Tab in Microsoft Excel for Office Today
There are a lot of different tools in Microsoft Excel, but not all of them are available by default. Many of these tools are found… Continue Reading How to Get the Excel 365 Developer Tab in Microsoft Excel for Office Today
How to Find the Median in Excel for Office 365
Microsoft Excel is much more than just a simple table in which you can sort and display data. It can also be used to perform… Continue Reading How to Find the Median in Excel for Office 365
What is Excel Compatibility Mode?
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… Continue Reading What is Excel Compatibility Mode?
How to Delete a Text Box in Microsoft Excel for Office 365
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… Continue Reading How to Delete a Text Box in Microsoft Excel for Office 365
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… Continue Reading How to Title an Excel Spreadsheet
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.… Continue Reading How to Create a Comma Delimited File from Excel
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… Continue Reading How to Show Excel UPC Numbers in Full
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… Continue Reading How to Make Negative Numbers Red in Excel 2013
How to Print an Entire Workbook in Microsoft Excel for Office 365
The steps in this article will show you how to change a print setting in your Excel file so that you can quickly print the… Continue Reading How to Print an Entire Workbook in Microsoft Excel for Office 365
How to Add Cell Borders in Excel for Office 365
When you create a new, blank spreadsheet in Microsoft Excel, and you are using the default settings, you see gridlines that indicate the size of… Continue Reading How to Add Cell Borders in Excel for Office 365
How to Change the Page Order When Printing in Excel for Office 365
Getting an Excel spreadsheet to print the way that you want can be a little frustrating. There are a lot of different options that affect… Continue Reading How to Change the Page Order When Printing in Excel for Office 365
How to Repeat the File Name on Every Page in Excel for Office 365
A printed spreadsheet is a difficult thing to customize properly. Whether you need lines between cells, you need it centered on the page, or you… Continue Reading How to Repeat the File Name on Every Page in Excel for Office 365
How to Remove All Row Shading in Excel for Office 365
It’s common for someone creating a spreadsheet in Microsoft Excel to want to draw attention to specific bits of data. One way that this is… Continue Reading How to Remove All Row Shading in Excel for Office 365
How to Turn Off Feedback Sounds in Excel for Office 365
It can be helpful when you are using a program to receive some sort of notification if you have completed a task. It can also… Continue Reading How to Turn Off Feedback Sounds in Excel for Office 365
How to Make an Entire Row Yellow in Excel for Office 365
Once you’ve finished adding the data to your spreadsheet, your attention typically turns to make sure that the data is presented in a way that… Continue Reading How to Make an Entire Row Yellow in Excel for Office 365
How to Hide the Scroll Bars in Excel for Office 365
When you are working with a lot of data in an Excel spreadsheet, screen real estate becomes very important. Constantly having to scroll to see… Continue Reading How to Hide the Scroll Bars in Excel for Office 365
How to Add Page Numbers in Excel for Office 365
Excel spreadsheets are usually easy to read on a computer screen without changing too many settings. Things can get a little tricky if you have… Continue Reading How to Add Page Numbers in Excel for Office 365
How to Clear a Print Area in Excel for Office 365
Have you ever gone to print a spreadsheet in Excel, only to have your pages broken up in weird spots, or certain rows or columns… Continue Reading How to Clear a Print Area in Excel for Office 365
How to Switch to Legal Page Size in Excel for Office 365
When you create a new spreadsheet in Microsoft Excel, that spreadsheet will use the default page size for normal documents. This is dictated by your… Continue Reading How to Switch to Legal Page Size in Excel for Office 365
How to Add a Dollar Sign in Excel for Office 365
There are many ways that you can customize a spreadsheet in Microsoft Excel. From options like adding a row to the top of every page… Continue Reading How to Add a Dollar Sign in Excel for Office 365
How to Hide the Formula Bar in Excel 2013
The formula bar above the cells in your Excel spreadsheet provides a convenient, centralized location for you to view and create formulas in your cells.… Continue Reading How to Hide the Formula Bar in Excel 2013
How to Use Narrow Margins in Excel for Office 365
Sometimes when you have a spreadsheet that you need to print in Office 365, it might seem like the margins surrounding your data are much… Continue Reading How to Use Narrow Margins in Excel for Office 365
How to Print Gridlines in Excel 2013
You might be interested in learning how to print gridlines in Excel 2013 if you have printed out a document and found it difficult to… Continue Reading How to Print Gridlines in Excel 2013
How to Repeat a Row at the Top Of Every Page in Excel 2013
Printing the same row at the top of every page in an Excel spreadsheet provides a simple way for people to know what type of… Continue Reading How to Repeat a Row at the Top Of Every Page in Excel 2013