Formula to copy multiple cells onto another sheet
Tue, 8 Jul 2008 20:24:34 -0700
I have a worksheet containing names and address that are repeated onto other
sheets based on criteria in another column. What formula if any can I use to
determine if that person meets that certain criteria to automatically copy
the 3 columns that the name, phone, and address are located in to another
sheet ...
|
How do I combine MACROS and functions?
Tue, 8 Jul 2008 16:33:02 -0700
I'm copying and pasting onto excel from an accounting program, and it's
pretty inconsistant. Whenever a new heading pops up, it either deposits the
first cell in the A column, and the second cell in the C column, or it
deposits the first cell in the B column, and the second cell in the C column.
I can writ ...
|
error message after install office 2008 mac
Tue, 8 Jul 2008 13:42:01 -0700
After install is complete get this message " There is a problem with the
office data base. Office might not be able to access the database or data
base file might be damaged.....To rebuild the data base open MS Office
2008/office and then open MS database utility. For more info open the data
base utility ap ...
|
Sizing a picture inserted in an Excel Spreadsheet
Tue, 8 Jul 2008 12:41:10 -0700
One of our users has requested that we insert a landscape oriented graph in
the middle of one of our spreadsheets. I scanned the form to a pdf file and
then to a jpeg. When I insert it in Excel, it runs off the page. If I set
the page size to legal, it still prints on 2 pages, but if we hold the pages
toge ...
|
how can i delete automatic page breaks in excel
Tue, 8 Jul 2008 08:33:02 -0700
I have copied an excel spreadsheet from my computer 2003 version to another
computer with 2007 version. It was meant to be only 1 page but comes up in
the 2007 version as 9 pages.I can't seem to remove the page breaks as they
are broken lines (automatic).Help!!!!!!!
I really need this to fit ti 1 page ...
|
Cursor in Excel 2007
Tue, 8 Jul 2008 01:37:00 -0700
I just started using excel 2007, when i select multiple ranges of cells using
the control key, I can see the box surrounding the cells the first time,
however when selecting the second range of cells, I can't see the box around
the cells, additionally there is just the box no shading to show the
selection, d ...
|
EXCEL Wild Cards
Mon, 7 Jul 2008 13:29:03 -0700
I'm having a problem with wild cards (*,?,!) when doing the vlookup function.
Unfortunately, my comparison data contains these characters so I end up
picking up the wrong data most of the time. Is there any way to turn these
wild cards off?
Thank you in advance,
Scott ...
|
|
|
Keyboard Formatting of a Cell
Mon, 07 Jul 2008 15:48:07 -0400
In another spreadsheet program long ago, it was possible to type an
apostrophe preceding text that is being entered into a numbers-formatted
cell, the the text was treated as text. For example, in Excel 2003, if I
type "04/04/08" in a General cell, Excel converts the entry to
"4/4/2008". If I typed "'04/04/0 ...
|
Driving me CRAZY~ please help
Mon, 7 Jul 2008 11:29:02 -0700
I just signed up for the free trial version of Microsoft Office 2007. Word
and powerpoint are both workig, but Excel (the program I need the most) wont
let me type in the cells! All of the tabs are inactive.
Could someone please help? I am extrememly frustrated and MS seems to want
to charge me for assista ...
|
How to I save this page in xls and keep the formatting?
Mon, 7 Jul 2008 10:28:01 -0700
http://www.mol.gov.ae/documents-en/WageRegister(N).htm
Thanks! Any help wil be greatly appreciated. I've tried export from excel
but it doesn't keep the formatting. Does anyone have any suggestions? ...
|
