|
|
Subtotal and outlining by
Abe
In Excel 2007 how do I subtotal and outline automatically like I used to do
in 2003?
|
November 7th, 2008 07:54 PM
by Bob I
|
7 |
98 |
|
|
New worksheet is in compatibility mode by
Abe
I have been using Excel 2007 at work for several months now. Just yesterday,
I noticed that when I create a new worksheet, it is in compatibility mode...
( 1 2)
|
February 9th, 2009 10:34 PM
by Abe
|
13 |
139 |
|
|
highlight every other row by
Abe
Hey all, is there a way to highlight every other row automatically in an
excel file. I have a list of names and it gets kinda blurry staring at the
white...
|
|
1 |
93 |
|
|
Hiding carriage return by
Abe
I have an Excel spreadsheet that contains carriage returns in some of the
cells. This is necessary to get the lines to wrip where I want them to. On
my...
|
|
1 |
72 |
|
|
|
February 25th, 2006 04:09 AM
by Abe
|
1 |
67 |
|
|
Extracting data from large range by
abe1952
Someone used Excel (2003) like an old fashioned paper spreadsheet. About 50
names on column A. Column headings in Row 1 are program numbers. Columns B to...
|
November 4th, 2009 02:05 AM
by abe1952
|
3 |
150 |
|
|
Problem with 2007 saved as 2003 by
abe1952
I have a 2007 worksheet that I save as a macro-enabled file in 2007. It has
many tabs, with about 15 tabs feeding into 5 intermediate tabs. The 5...
|
October 27th, 2009 11:16 PM
by abe1952
|
2 |
148 |
|
|
coding a list by
ABE25
Hi.
I have a survey that I have to enter on excel, and I wanted to know if there was a way to code the choices (ie: 1=health center, 2=hospital, 3=health...
|
|
2 |
116 |
|
|
|
|
3 |
95 |
|
|
sorting rows of data by
AbeAbeAbe
I have a worksheet which shows many rows of data from 7 vendors. Each of the
7 vendors are listed in columns. I want to sort the values of each cell in
each...
|
February 21st, 2007 03:49 PM
by Joel
|
7 |
64 |
|
|
|
|
2 |
113 |
|
|
|
June 3rd, 2009 05:04 PM
by Abeba
|
0 |
122 |
|
|
|
|
2 |
79 |
|
|
Coversion of Foreign Currency by
abee
I have a xlw file with 9 sheets - each one holding a different type of
financial report. All of teh amounts are in a foreign currency. How can I
enter the...
|
|
1 |
116 |
|
|
Comparing data between two columns by
ABeezy
I have a worksheet with two columns that I need to compare data between. I
need to see what is different between one column and the next. There are
number...
|
May 13th, 2010 02:18 PM
by ABeezy
|
4 |
161 |
|
|
|
September 13th, 2005 04:09 AM
by Abel
|
2 |
188 |
|
|
|
July 27th, 2004 05:42 AM
by KUEI
|
1 |
160 |
|
|
go back in pivot tables by
Abel
when you go back to previously created pivot tables, it won’t let you do anything to it (change fields, go to layout) apart from allowing you to trace it...
|
July 28th, 2004 03:40 PM
by BrianB
|
1 |
560 |
|
|
|
August 24th, 2009 09:31 PM
by Bob I
|
2 |
117 |
|
|
Connecting Excel 2007 to MySQL db? by
Abel MacAdam
Hi,
I would like to set up a complete new report in Excel which needs to get
data from a MySQL database. I have Excel sheets where the connection works
(the...
|
|
0 |
106 |