Limit No of Colums

  • Thread starter Thread starter loscherland
  • Start date Start date
L

loscherland

Excel worksheets by default provide columns 'A' to 'IV'.

How do you delete colums/rows from a sheet?

ie. So when you open your worksheet it will only display colums A - H
Rows 1 - 40 (You wont be able to scroll any further accross or down th
page through blank cells
 
Select the *entire* column that is past (right of) what you wish to be the
end of the sheet and:

<Ctrl> <shift> <RightArrow>
This should select everything out to column IV.
Right click in the selection and choose <Hide>.

Do the same for your rows, using the <DownArrow>.

If data is somewhere within your selection, you may have to repeat hitting
the arrow keys until you see column IV and row 65536.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Excel worksheets by default provide columns 'A' to 'IV'.

How do you delete colums/rows from a sheet?

ie. So when you open your worksheet it will only display colums A - H,
Rows 1 - 40 (You wont be able to scroll any further accross or down the
page through blank cells)
 
Yea i'm aware of that, but it's doesn't really solve the problem.

If you select a row of information, copy & paste it into a differen
workbook, it will still copy all the blank cells

For example.

If a row cotains 10 colums of info (A - J) & the rest are blank...

You copy the row

Paste it into another workbook, which has formula in rows 11 - 20,

It will paste all the blank cells over the formula in the othe
worksheet.

(& Simply selecting the cells A1 - A10, & then copying & pasting the
isn't practical if you have 100 colums in a row
 
Couple of options.

1. Hide the columns you don't want to be visible.

2. You may want to try setting the Scroll Area.

This setting will not remain after closing the file.
Place a code line in the Workbook open event to set it
each time when you open the workbook

Private Sub Workbook_Open()
Sheets("Sheet1").ScrollArea = "A1:H40"
End Sub

Adjust to your sheetname and range.

Gord Dibben Excel MVP
 
Excel has 2^8 columns * 2^16 rows, it's absolute and nothing can change that. The real
problem in this case is selecting/copying entire rows, they contain empty cells and so
they will be copied and pasted. Copy just the stuff that needs to be copied and that's it.

I know you said it isn't practical. But that's just how things are anyway. If this is a
repeating operation then you should have a macro controlling it instead of mousing around.
A good macro can do these things well.
 
Back
Top