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
Hiding standard tools.27 Sep 2007 07:47 GMT2
If I take out the formatting and standard tools also tabs at the bottom of
the page and then save it. If I now email this to someone will their copy
show the same when it is opened or will it depend on how they have `set`
their excel, in other words will it reveal what I have ...
not able to see the blinking cursor while editing cell27 Sep 2007 05:26 GMT2
For some reason when I edit a cell in excel I am not able to see the
blinking cursor. The formula bar shows where the cursor is and rather
than looking at the cell I am editing i have to look at the formula
bar. I find it extremly distracting.
Securing a worksheet vs. HTTP27 Sep 2007 04:13 GMT3
Suppose a worksheet is secured (user may not edit cells, select cells,
format cells, etc.). If the file is served via http, it seems as if these
security settings are not regarded. Is this correct, or do I make some
error.
Cut and Paste without taking borders27 Sep 2007 03:16 GMT6
This has driven me nuts for years, and it seems so basic:  I have a
spreadsheet with some borders around the outside of an area, and all I want
to do is say move a value from the upper right corner of the area to
somewhere in the middle.  If I cut and paste, it not only takes the ...
OFFSET Function - what is it doing?27 Sep 2007 00:33 GMT2
I'm trying to implement some functionality using the OFFSET function, but do
not understand what the two optional variables are doing.
For example, I am happy that for the range below, OFFSET(A1,1,2) will return
the value "c2"
hide formulas27 Sep 2007 00:27 GMT5
Excel 2002 SP3
Win XP HE
Hi,
I have a spreadsheet that has quite a few formulas that I want to
Using arrows (keys) to navigate in Excel26 Sep 2007 22:57 GMT3
Not sure if I can do this but only way I can navigate between the
boxes is if i press it with the mouse or if I use TAB and thats
navigate it only to the next box (forward) if i press arrows
Up,Down,Left or Right I am moving whole spreadsheet....so is there any
Formula26 Sep 2007 22:38 GMT3
I am created a table containing weekly total of overtime for a number of
employees (input table tab). I now want to create a chart (weekly overtime
tab) for the weekly overtime. I want to be able to enter a date for a
specific week and only create that week's chart.
MAJOR PIVOT TABLE PROBLEMS26 Sep 2007 22:24 GMT1
Trying to make an inventory ledger that displays all products, with
all their transaction no's and dates subcategorised under the products
using excel pivot tables.
The problem was that If i kept row fields as product, under that
Assigning a macro to a button26 Sep 2007 21:42 GMT5
I under the impression that when I created a button on a worksheet,
that a dialog box would appear asking me to choose a macro to assign
to the button.  This does not happen even though I have macros
available in the open workbook as well as in personal.xls.  How do I
Need Help with a Sum of a Product of a Currency and Product26 Sep 2007 20:49 GMT1
Does anyone have a way to simplify this formula and make it so it
automatically includes newly added rows or cells?
=SUM((SUM($K$9:L9)*$H$9),(SUM($K$11:L11)*$H$11),(SUM($K$13:L13)*$H$13),
(SUM($K$15:L15)*$H$15),(SUM($K$17:L17)*$H$17),(SUM($K$19:L19)*$H$19),
how can I make 2007 excel look like 2003 excel?26 Sep 2007 18:26 GMT1
I am not convinced that the 2007 interface is better.  Please tell me how to
make the 2007 excel look like , act like 2003.  PLEASE...........
Need help modifying a macro26 Sep 2007 18:19 GMT1
Hi.  I have a macro that works off of a master sheet and creates a new
worksheet for every block of 25 records.
FirstSheetname = ActiveSheet.Name
Lastrow = Range(Cells(1, 1), Cells(Rows.Count, 1)).End(xlDown).Row
BUG in 200726 Sep 2007 18:16 GMT3
put in 850 in a1
in b1 through b10 put in 77, 77.1, 77.2,77.3 etc
in c1 put =$a$1*b1 and fill down through c10
line graph c1:c10 - it is linear
Formula Question26 Sep 2007 17:24 GMT1
Hi all...
I am trying to figure out how to build a formula in Excel.  What I want to
do is to be able to calculate a loan value.  I know the interest rate, the #
of payments and the month principle and interest payment I want to make.  I
 
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.