Search the site for help on a problem you have right now or browse the lessons below to improve your skills. We're adding new lessons all the time, so check back often.
Calculate a running total of a column of cells in Excel
If you have a column of numbers and you want to calculate a running total of the numbers alongside, you can use the SUM() formula combined with a clever use of absolute and relative references.
Scale your spreadsheet to fit on one page when printing from Excel
Printing from Excel can be very frustrating, especially if your spreadsheet is too wide or too tall to fit on a single page.
You can use the Scaling option in Page Setup to set limits on how many pages wide and tall your document should be when you print it. The problem with that is that you can find your page fits onto one page, but becomes too small to read. Not only that, but Excel ignores any manual page breaks you’ve entered. This lesson explains how you can print your spreadsheet so it automatically scales to be one page wide without forcing the rows into a single page.
Scale your Excel spreadsheet to fit your screen
If you work with large Excel spreadsheets, you’ll probably know the hassle of scrolling left and right, up and down as you try to work with all that data. You can use the Zoom feature to make the spreadsheet smaller and fit more onto the screen, but that doesn’t always give you the result you want. Often, it will make your spreadsheet too small or not small enough.
Select cells quickly and easily in Excel using the keyboard instead of the mouse
Once you get used to using Excel, you can find that using the mouse to select data in your spreadsheet is somewhat slow and time consuming. Here’s a quick technique for selecting a range of cells in Excel.
Use the keyboard to move between worksheets in a workbook
One of the last keyboard shortcuts I mastered in Excel was moving between worksheets. Fortunately it’s easy, and you don’t need to wait as long as I did.
Quickly enter a formula in multiple cells
Entering the same formula or value into multiple cells can be time consuming and boring. Most people, if they want to enter the same formula into a row or column of data, will enter the formula in the first cell, then copy and paste it into the rest of the cells where they need the formula. This lesson shows you an even faster way to do it.
Calculating the current date and time in an Excel spreadsheet
There are many scenarios where you may need to use the current date and time in your spreadsheets. You may simply need to display the current date in a spreadsheet report. Or, you may need to perform a calculation that uses the current date or time. This lesson shows you how to enter a formula into a cell in Excel that outputs the current date and/or time, and updates automatically as time passes.
Select all the blank cells within a range of cells
If you have a range of cells, of which some contain values and some are blank, and you want to select just the blank cells, there is a quick way to select those blank cells that doesn’t involve manually clicking on every one.
Use the SUM function to add up a column or row of cells in Excel
There are a variety of ways to add up the numbers found in two or more cells in Excel. This lesson shows you how to use the SUM function to add up cells, rows and columns of cells in Excel.
- « Previous
- 1
- …
- 7
- 8
- 9
Additional Info
Join our mailing list
