Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |