A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Setting up and Configuration Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Have Excel display an error rather than rounding # to fit column by Frank
Excel can be misleading when it helpfully rounds your numbers to fit the existing column width. In most instances I would prefer that, for example, the...
July 25th, 2006 06:35 PM
by Dave Peterson Go to last post
1 230
Data Validation skips rows by JK
I am using data validation to prevent duplicates in a column and the validation i am using is =COUNTIF(A:A,A1)2 .This works on some sheets but on others, it...
July 25th, 2006 09:15 AM
by Max Go to last post
1 155
Remove a Personal xls by JK
I created a macro which unfortunately applied to all workbooks.Each time i open a existing workbook, a personal xls open with it.I uninstalled office and...
July 25th, 2006 03:30 AM
by Gord Dibben Go to last post
5 192
Excel 2000 bad start up by JW
Loaded office 2000 on XP home machine. All programs run OK exept Excel. On start up A MS error report is created. In the log the system is reported as Windows...
July 25th, 2006 01:26 AM
by JW Go to last post
0 170
how to calculate $1000/year at 5% for 25 years showing each year by HELP!
I need a formula or some way to figure out how to show an investment of $1000 per year at 5% for 25 years. and I need to show each years interest accrued and...
July 25th, 2006 12:58 AM
by HELP! Go to last post
0 186
How do you return current ROW number to definition in NAME function? by Franz Verga
Jim wrote: I have a two worksheet excel program, and it is being designed as a sort of commodities "inventory net worth" program. First sheet (Daily...
July 24th, 2006 04:13 PM
by Franz Verga Go to last post
1 134
Menu Bar by Boyd
I'm having the same problem someone else did. While attempting to use the Customize function on the Tools menu (on the top menu bar), the Tools dropdown...
July 24th, 2006 12:43 AM
by Boyd Go to last post
2 147
Copy/Paste over rides data validation by JK
Hello, The data validation response i received on my intial posting worked when you manually key in the same value preventing duplication but when i tried to...
July 23rd, 2006 03:39 AM
by Alan Go to last post
1 135
how do I insert a formula into Excel and number not disappear? by ruth
I am using Excel and I am a novice. I am trying to type my formula in the formula bar but then the number that I want to place in the cell disappears. When I...
July 22nd, 2006 09:35 AM
by Max Go to last post
1 155
how to setup autosave in excel 2007 by dv8
Hi Could someone please tell me how to setup excel 2007 for autosave, ie how to find it to begin with and then how to make adjustments to the time how often...
July 22nd, 2006 09:25 AM
by dv8 Go to last post
0 258
Rookie Alert- by kss
Need simple formula for finding 30% of a number
July 22nd, 2006 09:15 AM
by Max Go to last post
3 175
how can I have Excel accept date in format dd/mm/yy ? by Trucci
I set the date format with regional settings "Italy" how ever I still have to enter date as mm/dd/yy while we are used to write it dd/mm/yy. Did I did the...
July 21st, 2006 10:04 PM
by Marcelo Go to last post
3 131
custom toolbar looses buttons when closed by Charlie G
Hi all, I've crossposted to three groups as I'm not sure of the best location. Apologies if this breaches protocol. my custom excel toolbar (office97) with...
July 21st, 2006 07:10 AM
by Charlie G Go to last post
2 142
how to delete duplicate records in a row by Christian
Hi. I was browsing the topics in the forum and most of the things I found are deleting duplicates involve entire rows. My problem is this, I need to delete...
July 21st, 2006 01:39 AM
by Christian Go to last post
2 108
CATCHING DUPLICATE INFORMATION IN DIFFERENT CELLS SAME PROGRAM by lisa
I am working in excel and need to have a warning when information previously keyed is being duplicated in the same colums. Example: column B is always...
July 20th, 2006 05:21 PM
by Gord Dibben Go to last post
1 104
missing data excel 2000 to excel xp by Lynda S
I have created a database in excel 2000. To gather the data from the database l have used the template wizard. I need to load the database onto my computer...
July 19th, 2006 02:17 PM
by Lynda S Go to last post
2 134
input # on sheet 1, pulls all info for # from sheet 2 by moochx5
I have two sheets in excel. Sheet #2 has info in A1 through Af, 400 items listed down, all items have a unique number. When I enter that number in sheet one...
July 19th, 2006 10:43 AM
by roundabout Go to last post
1 111
How do I change the color of the autofiler indicators? by RaySar
The autofilter indicators (the little black or blue triangles) are difficult to tell the difference between unfiltered (black) or filtered (blue). Can I...
July 19th, 2006 10:12 AM
by roundabout Go to last post
2 127
Can you change the colour of an Excel autofilter arrow?? by roundabout
Though of course you could use a worksheet event macro? Private Sub Worksheet_Change(ByVal Target As Range) Dim af As AutoFilter Dim fFilter As Filter Dim...
July 19th, 2006 10:05 AM
by roundabout Go to last post
0 99
shortcut: copy cell right down by Khoshravan
Is there any short cut to copy just above cell to its bellow cell? -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan
July 19th, 2006 08:26 AM
by Stefi Go to last post
1 120
Post New Thread


Display Options
Showing threads 2241 to 2260 of 5209
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:03 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.