Named Ranges In Excel

Resolved · Low Priority · Version 2003

Fri 25 Apr 2008, 16:42 Delegate Gareth said...

Gareth has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Named Ranges In Excel

There is an option to ignore blank cells but I have found that if I select a range including blacks sometimes it ignores them and sometimes it doesn't. Why is this the case?

Mon 12 May 2008, 00:53 Trainer Tracy said...

RE: Named Ranges In Excel

Hi Gareth,
It could be that you may have put a space in the cell and the computer recognises it as a character though you cannot see it?
Tracy

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Hide columns in an Excel 2010 Worksheet

If you don’t want part of the Excel worksheet to be visible or when you don’t want certain data to appear in print outs, then a simple solution is to temporarily hide a column or multiple columns.

Hiding a single column:

1)Right click on the column header of the column you want to hide (this is the grey bar along the top edge of the worksheet)
2)Choose Hide from the menu
3)This column will now be hidden from view

Hide more than one column:

1)In the column header drag select to highlight the columns you want hidden
2)Right click and choose Hide from the menu

View all Excel hints and tips