Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / January 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
how to set tab spaces in excel?26 Jan 2008 23:32 GMT5
Some one has changed the tab spacing on my computer so now it jumps from A to
G, how do I get it back to moving one cell at a time?
VLookup with criteria and delete row26 Jan 2008 21:29 GMT5
What is the best code to use to look for a name ( col A) and delete the whole
row.
Signature

capt

Protection26 Jan 2008 20:48 GMT1
We have several spreadsheets that feed into a report.  Is there any way to
protect the sheets to allow data entry but not allow to insert extra lines?
Copy a file remotely26 Jan 2008 20:20 GMT1
I want to copy a file from one folder to another in VBA.  Normally I would
open the file and then use savesas, but the file is a csv and you cannot open
in excel.
So is there a way to just copy the file?
Not detecting Open Workbook - Why26 Jan 2008 20:16 GMT7
I've written a application to write data from one workbook to another.  
Before the workbook actually writes to the other workbook, I'm looking for
the workbook to alert me if the Second Workbook is already open.  In the
event it is, I do not want it to run the rest of the ...
How do I make the gridlines go to the bottom of the page?26 Jan 2008 20:12 GMT3
I am trying to make the gridlines fill the entire page.  I am trying to make
an inventory sheet for my daughter to fill out.  Please help
chart is grayed out26 Jan 2008 19:38 GMT3
I have one spreadsheet where, whenever I am working in cells, the chart turns
into a big gray square.  If I click anywhere in the chart, it reappears, but
then goes back to gray as soon as I click a cell.  I have never seen this
before.  Any ideas about how/why and what I can do ...
Save as csv file option missing from Excel 200726 Jan 2008 19:12 GMT3
I want to save an excel file in the csv as this is the format my address
program wants for import.  BUT, when I go to "save file as" there is no "text
file" option, and no csv option under "other formats".  I formatted all cells
as text, and I deleted all the other sheets in the ...
How do I set caluculations to update automatically? Excel 200726 Jan 2008 17:57 GMT2
I have checked in the setup that 'update calculations' is set to automatic (
no need to manual F9) but when I use the spead sheet and amend figures, the
sum calculation does not update.
Excel 200726 Jan 2008 17:56 GMT4
How do I set the calculations to update automatically?
I have checked the settings have been set to update automatically.
(no need for F9)
Group and Outline on a Protected Sheet26 Jan 2008 17:06 GMT11
I have an Excel sheet that I use the Group (Data|Group and Outline|Group) to
group certain rows.  If I protect that sheet, I would not able to expand or
collapse the groups.  I tried turn-on various items (and all items) when I
protect the sheet, and it still would not let me ...
Merging Spreadsheets and Finding Matches and Exceptions26 Jan 2008 15:40 GMT3
I have two Excel spreadsheets that I wish to merge. One list has about 2600
names, the other about 800. The matching key is "user ID" How do I find the
matches between the two spreadsheets and how do I find the exceptions? The
fields are basic, first name, last name, used ID, and ...
How do I format text so that when the formula delivers the mixed     data, it looks right26 Jan 2008 15:39 GMT1
I'm using one formula to bring data from 2 cells (ranges actually)
into one cell.  The data is mixed; text with $X.00.  When the data is
delivered, the number is just an integer, no currency formatting.
              A                                                  B
Form View26 Jan 2008 15:18 GMT1
This is such a cool feature - No print option here, just visual.
Has anyone figured out how to print this?
Delete Empty Cell With Formula26 Jan 2008 15:02 GMT4
I need a macro to delete formulas within a cell when the answer to the
formula gives an emtpy cell.
Any ideas ?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.