Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I add a scroll bar to my spreadsheet?
I've built my spreadsheet and it is very long. It is pretty basic it just
allows me to put data in and totals it for me. I have placed the toals value at the top of the page to the right of my input cells and I cant see it when I scroll down to input new data with out scrolling back up to the top. i would like to put a scroll bar next to my input fields so that my totals values will be visible always. Can anyone help? |
#2
|
|||
|
|||
instead of a scrollbar, use Freeze Panes to keep the row or rows at the
top. Select the cell in column A in the row below your totals and choose Window/Freeze Panes. In article , "huckleberry" wrote: I've built my spreadsheet and it is very long. It is pretty basic it just allows me to put data in and totals it for me. I have placed the toals value at the top of the page to the right of my input cells and I cant see it when I scroll down to input new data with out scrolling back up to the top. i would like to put a scroll bar next to my input fields so that my totals values will be visible always. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Data From Another Spreadsheet | Excel Discussion (Misc queries) | |||
How do I convert exel spreadsheet to works spreadsheet? | Excel Discussion (Misc queries) | |||
scroll bar | Excel Discussion (Misc queries) | |||
Scroll Bar in Shared workbook | Excel Discussion (Misc queries) | |||
How do I cancel sending a spreadsheet by email? | Excel Discussion (Misc queries) |