Professor Excel

Comments 3

  1. Bob Fleming

    I get my filename and path by inserting

    =cell(“filename”) and it put it right where I want it (next to bottom row in spreadsheet so it shows when I print) . However, as I am working with several spreadsheets, the filename changes to the last spreadsheet worked with, so I constantly need to re-insert the correct filename. Very frustrating.

    Any solutions to stop my filename from changing. It should always reflect the corret filename for the spreadsheet I am working on, once I have inserted after the first time.

    Kindest,

    Bob

  2. Ben Moy

    Move the formula down 1 line; then, copy and ‘paste values’ in the original cell before you print.

Leave a comment

%d bloggers like this: