Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I limit the number of coloums?
I want only 4 coloums on a spreadsheet. How do I limit it to that number
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I limit the number of coloums?
You don't. But, you can hide the others or set the scroll area so that the
cursor doesn't got there. -- Don Guillett SalesAid Software "Dave Allen" <Dave wrote in message ... I want only 4 coloums on a spreadsheet. How do I limit it to that number |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I limit the number of coloums?
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. -- MattShoreson ------------------------------------------------------------------------ MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472 View this thread: http://www.excelforum.com/showthread...hreadid=536840 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I limit the number of coloums?
Select columns E thru IV
(You can do that by pressing F5 and entering E:IV) Menu FormatColumnHide HTH -- AP "Dave Allen" <Dave a écrit dans le message de ... I want only 4 coloums on a spreadsheet. How do I limit it to that number |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a limit number of characters for cells in pivot Tables? | Excel Discussion (Misc queries) | |||
expand number of rows from limit of 65,536? | Excel Discussion (Misc queries) | |||
How do I increase the limit on the number of import rows in Excel | Excel Discussion (Misc queries) | |||
Is there a limit to the number of worksheets in an excel file? | Excel Discussion (Misc queries) | |||
limit number of characters in a cell | Excel Discussion (Misc queries) |