Category Archives: Excel

Excel: 3 common error messages and what to do about them

Error #1: #NAME?

 

Error #2: #VALUE

 

Error #3: This message appears:

Full tip: Excel tip

Read Less

EXCEL: Emailing a Single Sheet from an Excel Workbook

SCENARIO: You want to email someone one sheet from your multi-sheet Excel workbook.

 

There is no “quick” way to do this. However…there are two ways you can send a single sheet…with a bit of work.

 

Full tip: Excel tip

Read Less

Excel: A built-in Dashboard Camera

Excel has a built-in CAMERA feature (no kidding! and it has for years!) that allows you to take a picture (or pictures) of a portion (or portions) of your spreadsheet – creating a visual reference on another part of your spreadsheet.

 

Full tip: Excel tip

Read Less

Excel : Freezing

If you have a long spreadsheet where the headings keep scrolling up and out of sight – you should turn on the FREEZE PANES function.

 

It’s been greatly improved since 2003 – especially if you have a “clean” spreadsheet (one where the first row (#1) is headings and all subsequent rows are records of data…basically a database-type spreadsheet.

 

Full tip: Excel tip

Read Less

Excel: Extracting dates

If you have a full date entered into a cell – but only need the MONTH or the DAY or the YEAR…

 

Full tip: Excel tip

Read Less

Excel: Be a Tipster

If you’re creating a spreadsheet into which someone else must do the data entry it might be wise offer them instructions – to guard against erroneous data entry.

 

Full tip: Excel tip

 

Read Less

Excel (Intermediate): Look Behind the (Equation) Scene

Scenario: You have a big huge spreadsheet – lots of equations. One particular equation that you are observing up in the Formula Bar…you’d like to analyze it a bit closer. You’d like to confirm the values that it is using – without having to look directly at or go to any of the cells that it is referencing.

 

You know that whenever the cell pointer is sitting on a cell – you can see the true contents of the cell up in the Formula Bar (just below the ribbon).

 

Without having to actual go to (or look at) one of the cells being reference in the equation – you’d like to know what’s is real value is.

 

Full tip: Excel tip

Read Less

Excel: Who Touched This?

If you need to know who has made a change to a spreadsheet – here you go. (This only works if the spreadsheet is saved on a share drive).

 

Full tip: Excel tip

Read Less

More on the Amazing Fill Handle

You are sitting on a cell that contains the word January (or Monday). You know if you drag the Fill Handle (the little black square located at the bottom-right corner of the cell pointer) and drag down (or across) that February, March (or Tuesday, Wednesday) will appear in the adjacent cells…

 

Full tip: Excel Tip

Read Less

Web Browsing: Two Page Tips

Scenario: You’re searching the web for a topic. You find many potentially good links. You click on one – but the page it takes you to is disappointing. Sometimes the BACK button is faded (unavailable). Grr…

 

Full tip: Web Browsing tip

Read Less