Solved

How do I add or remove a worksheet in Excel 2010

Posted on 2011-03-01
6
807 Views
Last Modified: 2012-05-11
I can't seem to find the command in Excel 2010 to add/remove worksheets.  In Excel 2003, the command "insert worksheet" did the trick.

I'm also using the quick access toolbar to display "document location", i.e., the file pathname, but find that the space available shows only a tiny fraction of the full path.  How can I expand the space?
0
Comment
Question by:jgaines22
6 Comments
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 35011049
Right click on any tab to see these commands.

Kevin
0
 
LVL 9

Expert Comment

by:McOz
ID: 35011079

simply click the new sheet tab (just to the right of the others at the bottom). Or, you can right-click on one of the sheet tabs, and choose "insert">"worksheet">OK
0
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 35011096
You can also press ALT, I, W.

Kevin
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 14

Accepted Solution

by:
BigBadWolf_000 earned 500 total points
ID: 35011375
To add sheet Shift+F11
To delete right-click on sheet tab and select Delete

I don't think its possible (yet) to expand the document location space
(however if you click on the pulldown arrow it selects the full path and you can copy)
or if you need to view it you can use the follosing formula in a cell, it will display the full path

=LEFT(CELL("filename"),FIND("[",CELL("filename"),1)-1)

Can do with macro too but that brings up security issues for macros
0
 

Author Comment

by:jgaines22
ID: 35011917
I entered BigBadWolf's formula, and got almost the entire expected result, but not quite.  The path appears in the cell, but is missing the file name.  Of course, I can view the filename at the top of the window, but it would be more convenient to see the complete path and filename in one place.

Can the formula be modified to show the whole enchilada?
0
 
LVL 14

Expert Comment

by:BigBadWolf_000
ID: 35013759
I tested this it should work....let me know

=SUBSTITUTE(LEFT(CELL("filename"),FIND("]",CELL("filename"))-1),"[","")
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now