Software

Ask something
Question Locked

Copy Worksheet tab in a cell

0 helpful
4 replies

by mario58

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,
Does anybody know how to copy the sheet tab name to a cell in the worksheet, without writing any code?

4 replies

by too_old

One can copy the sheet tab name while in the 'rename' or before hitting return when creating the tab name, then just paste to the cell. When copying the tab name, I just made sure it was smeared, typed c, then make sure the tab name is no longer smeared and cursor at the end before hitting return to retain the name of the sheet. Hope it works for you.

by mario58

Thank you Paul. It is just what I wanted. Thanks indeed for your wonderful and kind help.
Mario

This discussion is closed to new replies.