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 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Worksheet tab names15 Sep 2005 21:22 GMT4
Is there a way to reference a cell inside a worksheet to tell me th
name of the worksheet? I have say 6 different worksheets in a file
named Sales,Costs,etc and when I print the worksheets I want cell A1 t
disply the worksheet name
Cells that move with the rest of the worksheet15 Sep 2005 21:06 GMT5
How do you do this?  I know it is possible from when I took a class in
Excel, but I can't remember how to do it.
Take Rows from Sheet1 and use as headers on Sheet2 - SheetN15 Sep 2005 20:58 GMT1
I have 10 rows on sheet 1 that users fill in. I'd like those 10 rows to be
the top lines printed on all subsequent sheets. Is this possible? How?
Thanks in advance.
Find and replace according to conversion table15 Sep 2005 20:54 GMT5
I have a question about automating find and replace for text data.  I
havetbe replacements I want to take place.  Instances of A1 should be
replaced with the value in B1, A2 with B2, and so on.  There are
several thousand entries.  How can I use this information to do a
User defined formula - concatenate range15 Sep 2005 20:51 GMT4
I apologize if this is too lengthy.  I am using a User defined formula to
take a range of values in the workbook and concatenate them into one long
string value .  I also want them to be separated by commas.
Example (real data is much larger):
Retrieve deleted excel document15 Sep 2005 20:25 GMT2
Is there a way to retrieve a spreadsheet that have been overwritten?
Thanks
Drawing Lines15 Sep 2005 19:53 GMT2
Is there an easy way to draw lines around a range of cells where you can
specify to draw the line on the top, bottom, left or right side of the
range?
Thanks.
Help!15 Sep 2005 19:51 GMT2
Thanks for your help in advance. I am trying to figure out a way that
inside the same spreadsheet you can have different column width sizes.
Is there a way to divide the spreadsheet to allow this to happen?
Form Colors on a form change on a laptop pc15 Sep 2005 19:31 GMT2
When one of our users prints his Expense Report (an Excel form), it prints in
blue ink and he would like it changed to black.  Previously, the color of the
lines was set to automatic. I changed the color to black and it still prints
blue for him.  Is there a setting on his pc ...
how to limit cell data & (masks)15 Sep 2005 19:26 GMT3
how do you set the number of characters for input on a certain cell o
column
i knew this at one point, but when u don't use it, unfortunatly u loos
it...
Export each sheets as a CSV files15 Sep 2005 19:04 GMT1
I would like to save all the sheets in a workbook to MS-DOS CSV files.
It would be nice if I could export only the selected sheets but that not
really required.
Is there a free addin that will allow me to do that or maybe a macro?
Unwanted formating (excel 2000)15 Sep 2005 18:56 GMT5
We have to import a file (CSV) where data in a column is in "999:99" or
"99:99" format.
For unknown to me reason the built in logic treats that data as Time
and Excel converts some data in this column into wrong format.
how do I get a formula to not show the amount but still be there15 Sep 2005 18:52 GMT2
I need to have a formula entered but I do not want the zero to show
Sorting Column15 Sep 2005 18:27 GMT2
:confused:
Exporting tags from Autocad I end up with my first colum containin
data such as A6r ....A35r & A6 ......A55, how can I sort this column i
accending order by the number only, ignoring the letters....??????
Automatically Add Rows15 Sep 2005 18:23 GMT1
Is it possible to have Excel automatically add rows, ideally a new row
each month?  I know you can use dynamic ranges to increase the range
each month, but I'd like it to "physically" add a row in addition to
this, so that I don't have to manually insert a row every month.
 
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.