Excel Tip – Maximums

Have you ever wondered how many rows or columns there are in the newer versions of Excel? Or how many characters can I fit in one cell? Wonder no more, here are some of Excel’s max capabilities: Rows: 1,048,576 Columns: 16,384 Cells in a worksheet: 17,179,869,184...

Excel Tip – 3 Different Count Functions

Have you ever wanted to know how many entries were in a list in Excel? You can use the Count functions to give you an accurate number. The first Count function only counts cells that contain numbers. Will ignore any cell that has text in it    =COUNT(A2:A24) The...

Excel Tip – Scale to Fit

Ever have one of those spreadsheets that do not quite fit on one page, no matter what you do! There is a simple way to make it fit. When you have your spreadsheet open click on the Page Layout tab and go to the Scale to Fit group. If your spreadsheet is too long then...

Program Shortcuts on Taskbar – Win7 and Win10

Put shortcuts to all your commonly used programs on your Taskbar (bar across the bottom of your screen). Then it will be a 1 click process to start any program. Windows 7 users:  Click on the Start button, then All Programs. Scroll to one of the programs you use, such...

Excel Tip – 3 Different Count Functions

Have you ever wanted to know how many entries were in a list in Excel? You can use the Count functions to give you an accurate number. The first Count function only counts cells that contain numbers. Will ignore any cell that has text in it =COUNT(A2:A24) The second...

Excel Tip – Total Multiple Columns at Once

If you have columns similar to the example below there is an easy way to total them all at once. Select the empty cells beneath each column (where you want to see the answer). Click in the cell beneath the first column, hold down Ctrl and click on the cell underneath...