+ Reply to Thread
Results 1 to 2 of 2

Fixing/freezing cells next to each other

  1. #1
    Registered User
    Join Date
    05-27-2020
    Location
    Hungary
    MS-Off Ver
    2016
    Posts
    6

    Fixing/freezing cells next to each other

    Hello!

    Its hard to explain but i will try my best.
    I often work with pivot tables that i later examine and add a little note next to them in a different column, then after a week or so, i update the pivot table but the comments i added just get mixed up since the pivot tables size is different than before.

    Like this i have the pivot table and added comments to a few rows but tomorrow if i update this pivot table and i get 50 more rows into it, the comments won't stay next to these 2 columns as i intended them to be.
    K?pernyők?p 2023-12-13 111042.png

    Is there a way to somehow freeze them together in a way that the pivot table will still be usable?

    Thank you!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Fixing/freezing cells next to each other

    Perhaps have a look at https://contextures.com/excelpivottableccomments.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Freezing cells without freezing columns
    By jensslofstra in forum Excel General
    Replies: 2
    Last Post: 09-26-2018, 01:51 AM
  2. Help with freezing cells
    By rcarruth in forum Excel General
    Replies: 8
    Last Post: 08-26-2016, 05:23 PM
  3. [SOLVED] Need to validate contents of cells linked cells, highlighting those that require fixing
    By Hirad001 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-23-2015, 09:37 AM
  4. Freezing dta in cells
    By akj1944 in forum Excel General
    Replies: 2
    Last Post: 03-23-2013, 10:45 PM
  5. Freezing Cells
    By gandolff in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-31-2009, 11:04 AM
  6. Freezing cells
    By Qban in forum Excel General
    Replies: 1
    Last Post: 12-11-2005, 11:50 AM
  7. [SOLVED] Freezing cells...
    By ANDREW_B in forum Excel General
    Replies: 1
    Last Post: 01-04-2005, 01:06 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1