Results 1 to 5 of 5

Thread: Which buttons on computer to retain rows at top of page in excel

  1. 2nd July 2022, 11:49 AM #1
    gavinwibrow's Avatar
    gavinwibrow
    gavinwibrow is offline YarnMaster Silver Subscriber
    Join Date
    Oct 2011
    Location
    Fremantle WA
    Posts
    3,838
    Total Downloaded
    0

    Which buttons on computer to retain rows at top of page in excel

    The Control/Shift/Delete action post in the D2 section has reminded me that I've forgotten the sequence for permanently retaining a specified number of the first lines in a spreadsheet at the top of the screen as you scroll down - effect is something like a header in Word but better.

    Anyone know or recall?
    D4 MY16 TDV6 - Cambo towing magic, Traxide Batteries, X Lifter, GAP ID Tool, Snorkel, Mitch Hitch, Clearview Mirrors, F&R Dashcams, CB
    RRC MY95 LSE Vogue Softdash "Bessie" with MY99 TD5 and 4HP24 transplants
    SADLY SOLD MY04 D2a TD5 auto and MY10 D4 2.7 both with lots of goodies
    Reply With Quote Reply With Quote
  2. 2nd July 2022, 12:21 PM #2
    reefmagnet's Avatar
    reefmagnet
    reefmagnet is offline Master
    Join Date
    May 2021
    Location
    Mackay
    Posts
    170
    Total Downloaded
    0
    Not in front of a pc at the moment, but it is called Freeze or similar. look under View menu. You select the cell that will represent the first movable row and column before activating the feature
    Reply With Quote Reply With Quote
  3. 2nd July 2022, 01:11 PM #3
    gavinwibrow's Avatar
    gavinwibrow
    gavinwibrow is offline YarnMaster Silver Subscriber
    Join Date
    Oct 2011
    Location
    Fremantle WA
    Posts
    3,838
    Total Downloaded
    0
    Quote Originally Posted by reefmagnet View Post
    Not in front of a pc at the moment, but it is called Freeze or similar. look under View menu. You select the cell that will represent the first movable row and column before activating the feature

    Spot on - many thanks - its been about 10 years since I last needed to use that provision.
    D4 MY16 TDV6 - Cambo towing magic, Traxide Batteries, X Lifter, GAP ID Tool, Snorkel, Mitch Hitch, Clearview Mirrors, F&R Dashcams, CB
    RRC MY95 LSE Vogue Softdash "Bessie" with MY99 TD5 and 4HP24 transplants
    SADLY SOLD MY04 D2a TD5 auto and MY10 D4 2.7 both with lots of goodies
    Reply With Quote Reply With Quote
  4. 4th July 2022, 10:18 AM #4
    Redtail
    Redtail is offline Master Subscriber
    Join Date
    Nov 2017
    Location
    West of Perth
    Posts
    277
    Total Downloaded
    0
    A bit late to the party, but yes ...

    Freeze Panes under the View tab. You can do top, left or both.

    There's a function in the Page Setup menu for doing something similar when printing - Rows to repeat at top / Columns to repeat at left.
    If at first you don't succeed, that's one data point. - xkcd
    ----------------------------------------------------------------------
    2011 Discovery 4 SDV6 HSE
    Reply With Quote Reply With Quote
  5. 4th July 2022, 01:48 PM #5
    NavyDiver's Avatar
    NavyDiver
    NavyDiver is offline Very Very Lucky! Gold Subscriber
    Join Date
    Feb 2010
    Location
    Melbourne
    Posts
    10,247
    Total Downloaded
    0
    Freeze or Spilt screen. You can drag and adjust the cell lines horizontally and vertically. I often Colour Fill top row or Left column two which I have fixed/frozen

    Great tool.
    Reply With Quote Reply With Quote
« Goss or Fuelmiser in-tank fuel pump | Series 3 - and other/related - brake shoes… »

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Search AULRO.com ONLY!
 Search All the Web!