macrobook.net

Hi,

Last week, I found a shortcut by accident.
I will share it with you to make your life easier.

Here it is:

On a cell try the following combination

CTRL+;

gives current date, where

CTRL+.

gives current time.

Have a nice day!

To write the full name of the file (/Folders…/Workbook Name/Sheet Name) copy and paste the formula below in to one cell

=CELL(“FILENAME”;A1)

If you want only the sheet name, try this:

=MID(CELL(“FILENAME”;A1);FIND(“]”;CELL(“FILENAME”;A1))+ 1;255)

Note: If you try the above formulas in an unsaved excel workbook, you won’t see anything in the cell. You need save the workbook first.

Note2: Look at the  ;A1 term in =CELL(“FILENAME”;A1) function. What if you remove the ;A1 term and write the formula only like =CELL(“FILENAME”)? It will give the same result.

Try it by yourself. Yes, it gives the same result.

Ok copy and paste it to a cell in sheet2. The cell will show:  “….sheet2″.

Return to sheet1. Look at the cell value. There should be a difference, isn’t it?

Canon 500d Canon LENS