Solved

How do I add or remove a worksheet in Excel 2010

Posted on 2011-03-01
6
810 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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

808 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