software

I have received a spreadsheet with columns numbered 1 - 4 to the left of
Column A1. They are locked amp; 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.

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 quot;Basics of using Subtotalsquot; (video) would describe them well
www.datapigtechnologies.com/ExcelMain.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Macklantaquot; gt; wrote in message ...
gt; I have received a spreadsheet with columns numbered 1 - 4 to the left of
gt; Column A1. They are locked amp; have a scroll bar at the bottom of the sheet.
gt; What are thiese columns/rows set up or used for? The columns are protected
gt; and I cannot find it's creator.
You can also get them via Data|Group and outline|group.

Try clicking on the /-'s and try clicking on those numbers at the top.

You can turn them off (I wouldn't!) by removing the subtotals or grouping or
just hide them by: Tools|Options|view tab|uncheck Outline symbols

(But don't do it.)

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

--

Dave Peterson