Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 79
Default How do I create 2 separate tabs in my workbook?

Hello,

I need to create 2 separate tabs in my workbook. How do I do this?

Thank you

Valerie
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,276
Default How do I create 2 separate tabs in my workbook?

Hi Valerie,
Could you be more specific, at the bottom of your spreadsheet you have the
different tabs, if you want to copy information from sheet1 into sheet2 you
can enter a formula lika
=Sheet1!A1



"Valerie" wrote:

Hello,

I need to create 2 separate tabs in my workbook. How do I do this?

Thank you

Valerie

  #3   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default How do I create 2 separate tabs in my workbook?

right click on an existing tab, select Insert/Worksheet

"Valerie" wrote:

Hello,

I need to create 2 separate tabs in my workbook. How do I do this?

Thank you

Valerie

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How do I create 2 separate tabs in my workbook?

Right click on the existing worksheet and choose Insert. Then choose Worksheet.

Valerie wrote:

Hello,

I need to create 2 separate tabs in my workbook. How do I do this?

Thank you

Valerie


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default How do I create 2 separate tabs in my workbook?

If by "tabs" you mean worksheets, then:
Insert menu/ Worksheet
--
David Biddulph

"Valerie" wrote in message
...
Hello,

I need to create 2 separate tabs in my workbook. How do I do this?

Thank you

Valerie





  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How do I create 2 separate tabs in my workbook?

And if you're using xl2007, there's a little "button" icon to the right of the
existing worksheet tabs. Click that one time.

Valerie wrote:

Hello,

I need to create 2 separate tabs in my workbook. How do I do this?

Thank you

Valerie


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
getting results on separate tabs josephone baker Excel Discussion (Misc queries) 1 January 29th 08 02:43 PM
Can you separate multiple tabs each into their own file hammermw Excel Worksheet Functions 2 February 28th 07 07:37 PM
V lookup in separate TABS! Bob Phillips Excel Discussion (Misc queries) 1 September 25th 06 09:12 PM
Select sheet tabs in workbook & save to separate workbook files stratocaster Excel Worksheet Functions 2 March 1st 06 03:35 PM
How can I create multiple rows of worksheet tabs in a workbook? kdzugan Excel Discussion (Misc queries) 1 March 8th 05 03:13 PM


All times are GMT +1. The time now is 03:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"