Excel Tables and Page Breaks
Mon, 10 May 2010 03:51:01 -0700
I have an issue on an Excel 2007 worksheet.
I have three Excel Tables (lists) on a sheet. Each table meeds to be
printed on a separate page.
I have inserted page breaks at the required sheet row. However when I
insert a row in a table - by right mouse click in a table and selecting
Insert, Table Row - ...
|
Looking for macro that converts a table that I can import into Access
Sun, 9 May 2010 18:32:16 -0700 (PDT)
Hi, I often have a table in excel with many columns and rows that I
want to import into Microsoft Access so that I can query against the
data. The easiest way to explain this is with the following example:
Original Table:
Age
Disease 0-7 8-12 13-15
Diabetes 25 50 100
Asthma 60 20 ...
|
Formula help please
Sun, 9 May 2010 11:26:30 -0700 (PDT)
Excel 2007
need a formula to look in column A and see a word then add up
associated numbers in column B from row 10 to 45 and in colum B cell
46 * the total by 5%
reworking an invoice to comply with GST and HST entries.
thanks ...
|
Today's date as a vertical line on Bar chart
Sun, 09 May 2010 09:42:49 -0400
There is probably a way to do this but I do not know how.
In XL 2007, on a dynamic stacked bar chart set up as a dynamic gantt
chart, is there a way to make today's date appear as a dynamic vertical
grid line?
Jeff ...
|
2003 Keeps the default workbook open
Sun, 9 May 2010 09:17:22 +0100
When I start Excel, it starts up with a blank workbook. If I immediately
open a saved file, it closes the blank workbook... All good...
except mine has stopped closing the blank one. So I always end up with 2
workbooks open, the one I opened and a blank one that I'm not interested in!
Is this a setting? if ...
|
NETWORK MARKETING
Sat, 8 May 2010 22:52:23 -0700 (PDT)
NETWORK MARKETING
****--------------------------------------------
http://sites.google.com/site/projecttrackingsoftware
*************
http://sites.google.com/site/networkmarkettings
**************
http://sites.google.com/site/spywareantiviruses ...
|
hanging indent in a cell
Sat, 08 May 2010 13:48:31 -0400
This may be asking too much of XL, but, using Excel 2007, is there a way
to make the text in a cell where wrap is selected appear as a hanging
indent? That is with all wrapped lines after the first one in that cell
be indented? ...
|
|
|
wrap command shortcut
Sat, 8 May 2010 14:44:54 +0100
Hi there.
I've looked in the customise toolbar but maybe not well enough. In Excel
2003, I'm looking for a way of being able to just click one button/icon to
wrap text in a cell. I need to do this a lot and would like not to have to
right click, go to the format cell>alignment tab.
Anyone know?
...
|
Update - Microsoft Responds to the Evolution of Community
Sat, 8 May 2010 00:02:38 -0700
What is Happening?
This message is to inform you that Microsoft will soon begin discontinuing
newsgroups and transitioning users to Microsoft forums.
Why?
As you may know, newsgroups have existed for many years now; however, the
traffic in the Microsoft newsgroups has been steadily decreasing for the
past se ...
|
Only Display Rows with Positive Values in Column C
Fri, 7 May 2010 14:09:22 -0700 (PDT)
I am trying to display data (in Sheet 2) based on what has been
entered in a seperate spreadsheet (i.e., in Sheet 1).
If there is a positive value in column C (in Sheet 1), then i want to
show the contents of that entire row (in Sheet 2). If there is not a
positive value in column C (in Sheet 1), then I want t ...
|
