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 / March 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
MS Excel don't know file's password24 Mar 2005 12:15 GMT2
Hello.  i'm trying to edit the a ms excel expense statement/re-imbursement
template.  unfortunately, it's password protected (and nobody at work knows
what it is).  does anyone know of a program that can crack an ms excel
password or know a way of over coming this problem?
Column Headings24 Mar 2005 10:15 GMT2
A colleague has Excel opening with the column headings as
numbers instead of letters.
Has anyone come across this before?  How did it happen and
how can we change it back?
Autofilling data on a form24 Mar 2005 08:52 GMT1
I get myself into the darndest things.  I have a requirement that calls for
creating a form in Excel that automatically inserts dates which change by
calendar quarter and state.  The user would like to be able to make one entry
and have the form autofill the correct dates ...
Page view vs. Print View24 Mar 2005 08:43 GMT1
One of my co-workers has a workbook that has 1 page that is huge on the
screen (2 screens wide) but prints normal - the problem I have is if I try
to copy/paste the page in to a new workbook it formats out to about 8 pages.
Any way to fix this?
Formula help : adding24 Mar 2005 07:44 GMT3
I a new to excel and as a learning project I am makig a list of my movies.  I
would like a formula that would add up the cells with text in them.  There
are some blank cells as seperation for alphabetizing and I don't want to add
those cells in my total.  There aren't any numbers ...
Opening old Publisher files24 Mar 2005 07:09 GMT1
I have many Publisher 97 files created on an old computer. When I purchased o
new XP machine I loaded the same 97 Publisher program, but it will not open
the files. I run a small business using this letterhead, etc. Suggestions?
MS Excel expense sheet password lost24 Mar 2005 06:48 GMT1
Hello.  i'm trying to edit the a ms excel expense statement/re-imbursement
template.  unfortunately, it's password protected (and nobody at work knows
what it is).  does anyone know of a program that can crack an ms excel
password or know a way of over coming this problem?
Cannot view visual basic functions24 Mar 2005 05:20 GMT3
I have had a spreadsheet emailed me which has some VB functions included.
I need to look at this code but I see nothing in the VB editor. The
spreadsheet seems to use these custom functions correctly.
Is there some trick to saving spreadsheets such that the VB code can be
How to stop save-as format warnings24 Mar 2005 02:39 GMT3
I don't use Excel to design the Sistine Chapel; I use it to keep simple
lists and tables, one page per file.  I don't want to save it in the
newest whiz-bang document format every time my boss forces yet another
"upgrade" on me; I want to save it in a backwards-compatible format
highlight range if cell contains desired data24 Mar 2005 02:30 GMT7
If any cell in column D:D contains desired data in string format (  i.e.
"Bill G" ), how would I highlight the data range in that respective row?
Example:
cell d4 contains the text "Bill G". Excel automatically colors the range
How to put Time or Date Only in Cell 1) Time HHMMSS 2) Date YYYYMMDD24 Mar 2005 01:32 GMT1
I need to have a cell = the current time in the format HHMMSS
And when I export as Comma Delimited or Fixed Length Ascii, I need for it to
remain in that format.
Ditto for Date as YYYYMMDD
edit Excel spread sheet24 Mar 2005 01:05 GMT3
I am a very new user of Microsoft Office....seven years using Corel....my
Daugher-in-law-to-be just sent me a spread sheet with guests names and
addresses to edit.  I was able to down load it after installing Excel but I
can't edit it.  Could some one give me detailed ...
How do I allow a macro to run on a protecetd sheet without the user having to enter the password?24 Mar 2005 00:08 GMT2
I have a macro (see below) that begins by unprotecting the active worksheet,
runs several subs, then protects the sheet again.  The user runs the macro
by clicking on a graphic in a locked cell.  The sheet is normally password
protected.  I'm pretty sure that something odd has ...
How to Copy Text to Fixed Length with leading Spaces ?24 Mar 2005 00:01 GMT6
I need to copy the text data in one cell to another cell and end up with
Fixed Length Ascii.
Example:
A1 = XYZ
Macro IF cells Contains ""; Then ""23 Mar 2005 22:23 GMT3
I was wondering of somebody was familiar with the possibility to start
different macro's if the contents of a cell I refer to different then I want.
For example: In most cases the Cell A38 on sheet "Quote" contains "General",
if so I want to activate macro "Sub ...
 
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.