General Betting
There is currently 1 person viewing this thread.
28 Apr 10
11:13
Joined:
Date Joined:
28 Oct 08
Sorry!!
But I have a spreadsheet with lots of values and it's getting longer and longer every day but information I'd like to be able to glance at is at the top of the doc. Is there any way to have it floating beside where the next values will be entered and have it trailing the next empty cell?
But I have a spreadsheet with lots of values and it's getting longer and longer every day but information I'd like to be able to glance at is at the top of the doc. Is there any way to have it floating beside where the next values will be entered and have it trailing the next empty cell?
sort by:
Show
per page
Replies: 2
|
By:
=OFFSET(A1,COUNTA(A:A)-1,0)
That is if there are no blank cells in column A Put that formula in a cell at the top somewhere you want to see the last value in a column, BUT NOT in column A Change A for the column with the values. |
|
By:
Go into Window Menu then select Split or Freeze options to do what you want.
|