Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 818
  • Last Modified:

How do I add or remove a worksheet in Excel 2010

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
jgaines22
Asked:
jgaines22
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
Right click on any tab to see these commands.

Kevin
0
 
McOzCommented:

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
 
zorvek (Kevin Jones)ConsultantCommented:
You can also press ALT, I, W.

Kevin
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
BigBadWolf_000Commented:
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
 
jgaines22Author Commented:
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
 
BigBadWolf_000Commented:
I tested this it should work....let me know

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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now