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 / New Users / September 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Remove last letter from column06 Sep 2007 19:55 GMT6
Hi,  I have a list of titles and some titles have a letter A or B at
the end.. is there a function/formula I can use to remove them if it
ends in A or B?
For example (my list):
Page numbers when printing multiple sheets06 Sep 2007 19:39 GMT2
I am trying to get my whole workbook to print out as a single document. I
select all 30 of the worksheets, and print. It works fantastically, except
the page numbering. It usually prints on about 125 pages, Sheet1 prints on
two pages, so the page numbering in the footer goes: ...
Copy a formula formatted as Text In Excel06 Sep 2007 19:35 GMT2
I have a UDF that returns the formula of a given cell in a text
format.  Is there anyway to have excel recognize that the result of
the function is a formula and not text.
Once I click on the cell, hit F2 to edit it and then enter, Excel
exit excel step by step06 Sep 2007 17:44 GMT5
When I double-click an excel file the following happens:
- excel opens
- a blank workbook opens (like a new workbook)
- the file which I selected opens in Excel
Formatting Cells using an If Statement06 Sep 2007 16:39 GMT4
Hi, I am wondering if anyone knows, is there a way to format a cell based on
it's value using an IF statement?  For example I want to enter a worksheet
function that would change a cells font color to red if it exceeds a certain
value.
Excel 2003:  Cannot access directory06 Sep 2007 15:00 GMT3
I have a second hard drive where I store my files.  The windows mapping
originally mapped it as drive "F".  I have added a 2nd DVD burner recently
and now my second hard drive is mapped to "G".  In my Excel 2003, under
Tools:Options, when I click the Save tab, it gives me an ...
Error when hyperlinking to PDF06 Sep 2007 14:50 GMT2
I receive this: "No program is registered to oen this file."
I have checked the PDF's permissions, paths, etc and all that side is fine.
The PDF's open FINE when going to the directory. Only errors when linking
from Excel (2003).
Metric conversion formula / function06 Sep 2007 14:48 GMT8
I'm modifying a worksheet for our Quality Control dept. where I have
to take metric dimensions (millimeters) off a print and convert them
into English / Imperial (inches) for the guys to check parts from.
Anybody know if there is a way to enter a metric dimension and have
checkbox06 Sep 2007 14:31 GMT1
I want to add a checkbox in a column so the user can check it for yes or no. Is there a way to do this?
character count06 Sep 2007 14:18 GMT3
How to count the character count in a particular cell.
Ex:
A1="Welcome to Excel"
count e in A1
Table of contents with hyperlinks to worksheets, plus "home" hyperlink06 Sep 2007 13:43 GMT2
I would like to find a way to insert a "Home" hyperlink on all
worksheets in a workbook. The hyperlink should link to Sheet1!A1 (my
table of contents worksheet).
Presently I have to enter the hyperlink one a time on each worksheet.
Delete rows from one sheet containing deatils on the second sheet06 Sep 2007 11:10 GMT4
I need help - please:
I have 2 Excel sheets:
1 – Contains all contact details (aaprx 900 rows)
2- Contains email addresses which have bounced back over the past 3 months
share/ link info between sheets06 Sep 2007 08:28 GMT2
I have created formulas is sheet 1. I want to create a table in sheet 2 using
totals from sheet 1. How do I work with formulas between sheets?
deleting rows from one sheet based on 2nd sheet06 Sep 2007 07:38 GMT1
I need help - please:
I have 2 Excel sheets:
1 – Contains all contact details (aaprx 900 rows)
2- Contains email addresses which have bounced back over the past 3 months
Write Code that creates expiration date06 Sep 2007 07:31 GMT2
I want to write a routine that allows someone to use the template for
a certain time period. After that time period, I want them to stop
using the program without renewing so the information stays current.
The following routine will work, except I want the value to be stored
 
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.