How to Start Excel in Text Import Wizard for data import
Thu, 10 Jul 2008 12:40:01 -0700
Can Excell be set up to start in the Text Import Wizard when opening certain
file extension types? Basicly jump through the initial Start Up and
subsequent selection of Data/Import External Data/Import Data/ Select File...
Would like to see Excell and Wizard opened anytime i select the file with
.___ exten ...
|
Hidden Formula Bar
Thu, 10 Jul 2008 04:47:01 -0700
When I open EXCEL, the formula bar is missing. I can reenable it be going to
Tools->Options->Formula Bar
but next time I log onto the computer the bar is gone again.
Any suggestions? ...
|
Sharing & Sorting workbooks
Wed, 9 Jul 2008 22:24:28 -0600
Need some help here. Don't know if this is even possible. Trying to create
a common log for 20 or more people. These workers will be entering data in
approx.
9 different categories, saving so everyone else can see data and sorting at
different times and on different categories. Then after all 24hrs of dat ...
|
setting excel 2007 default template folder
Wed, 9 Jul 2008 16:05:00 -0700
In Word 2007, there is a way to set the default folder for templates but I
cannot find the same option in Excel 2007. Anyone know where that might be? ...
|
Page Breaks for entire spreadsheet
Wed, 9 Jul 2008 12:32:07 -0700
I have a very large spreadsheet (over 17,000 records) and I'm printing about
15 pages per day.
When I first made the spreadsheet, the header, footer, and margin settings
limited me to 9 rows per page. I changed the footer and margin settings and
now I can fit 10 rows per page. How do I make this change for ...
|
Chamfer Cells
Tue, 8 Jul 2008 12:26:15 -0700
Hi,
I have a work sheet and the gridlines are tuned off.
The work sheet has a white backround and has groups of cells green in colour
within the white backround. Is it possible to chamfer the corners of the
green cells for aesthetic purposes?
Thanking you in advance. ...
|
Comment Default Format
Tue, 8 Jul 2008 10:43:00 -0700
I can't see how to change the default behaviour when a new Comment is started.
I want the default format for a new comment to be a different font face and
font size. ...
|
|
|
That didn't come out
Tue, 08 Jul 2008 09:22:57 -0700
Hey, it's pretty easy to do.
In the custom format, just type:
"MCY ID "#;"MCY ID "#;"MCY ID 00000";"MCY ID "@
Numbers are taken care of by the first 3 parts, and alphanumeric entries are done by the last (whatever text is entered in the cell will be placed where the "@" is). This doesn't make sure that o ...
|
Looking for an employee benefits tracking worksheet
Mon, 7 Jul 2008 21:16:00 -0700
Need a spreadsheet which will track availalbe vacation time based on
anniversary date and track sick time as it is earned and used. ...
|
Print range
Mon, 7 Jul 2008 22:04:27 +0100
I want to create a worksheet so that when I click Print, Excel will
automatically print the area defined a top left cell that contains a
particular value in a specified column and the lower right cell is a
manually defined offset from the top left.
In particular, the top left value is to be =TODAY() looked ...
|