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 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
How to add an arrow08 Mar 2007 23:41 GMT1
I have a front wooksheet which summaries the 4 other worksheets.
I want a quick way to show if the volumes are improving or getting
worse. So I wanted to put a bold green "up arrow" or red "down arrow"
in  the relative cells, but I do not know how to achieve this. At the
Cannot COPY & PASTE08 Mar 2007 23:03 GMT1
I am probably doing something very stupid. I have been using EXCEL since
it's inception, and have developed many worksheets and VBA code. I am not a
newbie.
My problem exists with one worksheet, no others. In fact, the problem does
* Need serious help with formula/function *08 Mar 2007 22:59 GMT4
Here's an example of what I need...
Cell            Value
_________________
D3          100.0000        <---------------- Random number entered
dates08 Mar 2007 22:54 GMT1
how to change text dates (03082007) to mm/dd/yyyy (03/08/2007
how do i save worksheet as a jpeg file08 Mar 2007 22:51 GMT3
i need to save excel worksheet as a jpeg file
Format cells for special characters08 Mar 2007 21:51 GMT1
I downloaded a "to do List" that has a function whereby entering "a" into the
cell, brings back the checkmark unicode character.
How is this set up?
Data Entry - Avoid Duplicates08 Mar 2007 21:45 GMT2
Is there anyway to set an alert or validation.. to avoid duplicates?
For example:
columnA
abc123
Macro Programing08 Mar 2007 19:23 GMT13
I do a payroll for my company on excel, and everyone but me is living in the
stone age.  They still haven't figured out =Sum(A1,A2). Anyways, I'm trying
to write a macro to help me make less mistakes.  If it was just straight
equations, it would look sort of like this:   ...
Pivot, MSQuery or crafty use of MATCH and OFFSET?08 Mar 2007 18:15 GMT2
Please can someone give me a leg-up for the following:
Prob1 - Easy (on same sheet)
Rows are names (eg Brown, Smith, Jones...)
Cols are Criteria (A, B, C, D...)
Admin password to Individual protected worksheets by users08 Mar 2007 17:53 GMT4
I have an excel workbook where each individual sheet is protected by
unique user.
I want to add a admin id & password to this workbook so that the admin
can access all sheets at the same time. (unprotect, unhide all
Calculating Time08 Mar 2007 17:15 GMT2
I need to calculate hours to be worked in one cell. This spreadsheet will
caluclate the hours scheduled for the week, then add them up and mulitply by
payrate:
       1                 Mon(2)         tue(3)       wed(4)          
Specify BOLD within a formula?08 Mar 2007 16:41 GMT6
I have a formula which looks up 2 text strings (at least part of them) and
concatenates them.  Is there any way to have the second text string display
in BOLD by somehow specifying this within the formula?
=LEFT(VLOOKUP(B12,Derivative,4,FALSE),FIND("(",VLOOKUP(B12,Derivative,4 ...
Increment Formula08 Mar 2007 15:45 GMT5
I use the following formula to pull values from an external spreadsheet. If
I use the Auto-fill option to populate cells in the destination file it
copies the formula exactly. How can I get it to increment the last digit
when copying down a column
Excel Merge08 Mar 2007 15:32 GMT1
I have been given an assignment to do a "mail merge" in Excel.  The
names and addresses are in a document in Excel and the person does not
want to have to have the information typed again.  Is this possible?
I believe a mail merge would have to be done in Word or Access.  By
Time Save msg box08 Mar 2007 15:31 GMT5
Is it possible to have a message box pop up every hour to remind
people to save the workbook, as we use a sheet for a period of 24 hrs
and often it is closed without saving,
i did use the auto save on workbook close event, but this is still not
 
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.