Thread: Tabs Names
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MDI Anne MDI Anne is offline
external usenet poster
 
Posts: 15
Default Tabs Names

Okie dokie... that's what I thought, but just wanted to check.

Thanks!!

"Jim Thomlinson" wrote:

Nope. Not without resorting to a macro. Depending on how many sheets it may
be quicker to just do it by hand than to write a macro.
--
HTH...

Jim Thomlinson


"MDI Anne" wrote:

Is it possible to change all of the tabs names in my workbook (using
something similar to "find & replace"??

ex: workbook tabs names:

Q107, Q207, Q307, Q407 (for quarterly reports in 2007)

Now I want to change the tabs to read:

Q108, Q208, Q308, Q408.

Is there a quick way?

Thanks!