Worksheet

  • Thread starter Thread starter melissa
  • Start date Start date
M

melissa

I have one worksheet with colums A - W. I want to be able to use colums A -
P than colums R - W. The colum Q would be seperation point from A - P. Is
it possible for me to seperate A - P and R-W and use the one work sheets as
two worksheets?
 
hi
back in the old days...before windows(multiple sheets)....before the mouse..
that was exactly the way it was done. You had no choise. and that is how we
got named ranges so that you could jump to the different areas of the sheet
quickly.
caution...
you wont be able to add or delete rows but you can add and delete groups of
cells from A-P and R-W but not entire rows. any thing that affects a row will
affect the entire row such as row hight and others.
i still use this technique but only on my own personal files. newer
spreadsheet users too used to working in the upper left hand corner of
multiple sheets tend to forget about multiple areas(ranges) on a single sheet.
can be done.....has be done....advantages and disavantages to both ways.

Regards
FSt1
 
Back
Top