<div>
Right click on any tab to see these commands.<br />
<br />
Kevin
</div>


Right click on any tab to see these commands.

Kevin

<div>
<br />
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 &quot;insert&quot;&gt;&quot;worksheet&quot;&gt;OK
</div>



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

<div>
You can also press ALT, I, W.<br />
<br />
Kevin
</div>


<div>
I entered BigBadWolf's formula, and got almost the entire expected result, but not quite. &nbsp;The path appears in the cell, but is missing the file name. &nbsp;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.<br />
<br />
Can the formula be modified to show the whole enchilada? 
</div>


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?

<div>
I tested this it should work....let me know<br />
<br />
=SUBSTITUTE(LEFT(CELL(&quot;fil<wbr />ename&quot;),FI<wbr />ND(&quot;]&quot;,CEL<wbr />L(&quot;filenam<wbr />e&quot;))-1),&quot;[<wbr />&quot;,&quot;&quot;)<br />

</div>


I tested this it should work....let me know

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


<div>
<div class="content wysiwyg-content">
I can't seem to find the command in Excel 2010 to add/remove worksheets. &nbsp;In Excel 2003, the command &quot;insert worksheet&quot; did the trick.<br />
<br />
I'm also using the quick access toolbar to display &quot;document location&quot;, i.e., the file pathname, but find that the space available shows only a tiny fraction of the full path. &nbsp;How can I expand the space?
</div>
</div>


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?

How do I add or remove a worksheet in Excel 2010

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.