I want only 4 coloums on a spreadsheet. How do I limit it to that number
D Dave Allen Apr 27, 2006 #1 I want only 4 coloums on a spreadsheet. How do I limit it to that number
D Don Guillett Apr 27, 2006 #2 You don't. But, you can hide the others or set the scroll area so that the cursor doesn't got there.
M MattShoreson Apr 27, 2006 #3 select columns E to IV and then hide them. To prevent users messing the 4 column structure up, protect your sheet and check the relevant boxes.
select columns E to IV and then hide them. To prevent users messing the 4 column structure up, protect your sheet and check the relevant boxes.
A Ardus Petus Apr 27, 2006 #4 Select columns E thru IV (You can do that by pressing F5 and entering E:IV) Menu Format>Column>Hide HTH
Select columns E thru IV (You can do that by pressing F5 and entering E:IV) Menu Format>Column>Hide HTH