View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David McRitchie
 
Posts: n/a
Default What are colums to the left of Column A for?

Hi Macklanta,
There are subtotals. Data, Subtotals
normally you can click on the number and that level of subtotals will appear.
Used in combination with Select Visible cells (alt+semi-colon) you can color
and boldface particular totals rows.

Very briefly mentioned on my sumdata.htm page, but you know what you
can search for in HELP and in Google..

I think "Basics of using Subtotals" (video) would describe them well
http://www.datapigtechnologies.com/ExcelMain.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Macklanta" wrote in message ...
I have received a spreadsheet with columns numbered 1 - 4 to the left of
Column A1. They are locked & have a scroll bar at the bottom of the sheet.
What are thiese columns/rows set up or used for? The columns are protected
and I cannot find it's creator.