Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Problems with long columns.
Hi all...
My spreadsheets are farly simple, but I have a problem. When I copy a formula all the way down a column, it creates spreadsheets that are thousands of rows long. Is there a way to paste the formulae only until the bottom of the used area? for example, I have nothing after 800, but choosing an column and pasting a formula will extend the spreadsheet to0 row 8000 or more. In a related vein, how do I jump to the bottom of a spreadsheet. Once I have pasted the formula, the columns are so long that using the scroll bar is not an option. Thanks for any tips! John |
#2
|
|||
|
|||
Use the control key in conjunction with Arrow down or
arrow right to get to the last used cell before the first empty cell (if your data is uninterupted, this will be the last row or column). Once you get there Ctrl+Shift+Arrow Up or left will highlight the area for your paste. You can also use the the Go to command (Ctrl+G) if you know where your data ends. -----Original Message----- Hi all... My spreadsheets are farly simple, but I have a problem. When I copy a formula all the way down a column, it creates spreadsheets that are thousands of rows long. Is there a way to paste the formulae only until the bottom of the used area? for example, I have nothing after 800, but choosing an column and pasting a formula will extend the spreadsheet to0 row 8000 or more. In a related vein, how do I jump to the bottom of a spreadsheet. Once I have pasted the formula, the columns are so long that using the scroll bar is not an option. Thanks for any tips! John . |
#3
|
|||
|
|||
Thanks! I am sure this will do it.
Thanks for the help! John "Anon" wrote: Use the control key in conjunction with Arrow down or arrow right to get to the last used cell before the first empty cell (if your data is uninterupted, this will be the last row or column). Once you get there Ctrl+Shift+Arrow Up or left will highlight the area for your paste. You can also use the the Go to command (Ctrl+G) if you know where your data ends. -----Original Message----- Hi all... My spreadsheets are farly simple, but I have a problem. When I copy a formula all the way down a column, it creates spreadsheets that are thousands of rows long. Is there a way to paste the formulae only until the bottom of the used area? for example, I have nothing after 800, but choosing an column and pasting a formula will extend the spreadsheet to0 row 8000 or more. In a related vein, how do I jump to the bottom of a spreadsheet. Once I have pasted the formula, the columns are so long that using the scroll bar is not an option. Thanks for any tips! John . |
#4
|
|||
|
|||
Ctrl End to get to the last cell & Ctrl Home to return
"JohnnyJomp" wrote: Hi all... My spreadsheets are farly simple, but I have a problem. When I copy a formula all the way down a column, it creates spreadsheets that are thousands of rows long. Is there a way to paste the formulae only until the bottom of the used area? for example, I have nothing after 800, but choosing an column and pasting a formula will extend the spreadsheet to0 row 8000 or more. In a related vein, how do I jump to the bottom of a spreadsheet. Once I have pasted the formula, the columns are so long that using the scroll bar is not an option. Thanks for any tips! John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing problems with columns and rows | Excel Discussion (Misc queries) | |||
print excel columns on less pages | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
print 1 long row(20 columns) in excel to one single page | Excel Worksheet Functions |