General Discussion - Page 553 - 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.

Thread / Thread Starter	Last Post	Replies	Views
Action button by Davey How do I insert an action button which will move me from one worksheet to the next?	October 27th, 2009 10:49 AM by Jacob Skaria	1	120
inserting rows inbetween rows of data ? by Azeem Need to insert 4 lines after each line of data in excel. Pls guide. If macros are to be used, also pls guide on how to run vb macros in excel.	October 27th, 2009 07:38 AM by Jacob Skaria	1	152
Nested IF statement by WIJ Hi all, This is the first time I have posted on here.. I am trying to make up the following nested IF staement (I am drawing alot of information from a...	October 27th, 2009 05:39 AM by WIJ	3	150
Worksheet tabs resized out of view below program window."missing t by Ayaire Hello, When I open a new Excel file, the window for that workbook will often be resized so that the bottom of the workbook is out of view, making it appear...	October 27th, 2009 05:01 AM by BSc Chem Eng Rick	1	120
How to set up: If cell X =1, value is A, if cell X =2, value is B by snowsaw Cell A1 could have one of 12 values. Each of those values is associated with one of 12 values listed in Column D. How do I get Cell A1 to know which value to...	October 27th, 2009 04:57 AM by BSc Chem Eng Rick	2	161
Strikethough in cells? by Bob Newman Excel 2007 When I enter information (text or numbers) into some cells it enters with a line down through it (like editing in Word). I don't know why this is...	October 27th, 2009 02:12 AM by Dave Peterson	4	182
Find the first letter in a cell by Corne In one column I have a text contaning numbers and letters e.g.: 10S1 143W1 1A9 etc. I want a second column containing only the first letter of these text....	October 27th, 2009 01:19 AM by Ron Rosenfeld	5	141
Excel 2007 AutoFilter problem by Sarah H. Hi, all, I recently started using Excel 2007 after having used older versions for many years. I am having a baffling issue with AutoFilters. I turn on... ( 1 2)	October 27th, 2009 12:12 AM by Sarah H.	16	314
First page number by Betti Punnett My first spreadsheet has 61 pages. My second (with different heading) has 42 pages. I want my second spreadsheet to start at page 62. I follow all instructions...	October 27th, 2009 12:09 AM by Gord Dibben	2	156
Macro to Save File to specific location when closing by paankadu Is there a way to have a macro automatically save a file when closing it down? Specifically looking for it to save in a certain location using the date as...	October 26th, 2009 11:52 PM by Gord Dibben	3	109
=LOOKUP(100^10,D:D) by Gilbert Can someone explain the above formula please? Thank you in advance	October 26th, 2009 11:18 PM by T. Valko	2	117
Find and replace results can the appearance of find be different? by LLS at DPW Using find and replace -- Can the results of the find be highlighted differently?	October 26th, 2009 11:16 PM by Gord Dibben	2	123
sum only certain figures in the column by Jack B Re Excel 97 -------- I want to SUM only the figures in J20:80 (put sum in J81) that do not have a blank corresponding cell in K20:80, but I can't figure out...	October 26th, 2009 11:16 PM by David Biddulph	2	125
Excel 2007 "Office Button" by lucy_o When I remote access my work computer fropm home, the "office Button" feature will not work. Is there some kind of security setting that causes this to...	October 26th, 2009 11:10 PM by lucy_o	0	115
Filter Question by Vic My filter is no longer showing total number of records in the left bottom corner (excel 2003). What should be done to restore that function? Thank you.	October 26th, 2009 11:03 PM by Gord Dibben	2	97
Check Register Balance by Janet How do I show a check register balance which changes with each entry in a designated single cell so I can easily link it to another document? -- Janet	October 26th, 2009 11:02 PM by T. Valko	8	146
Formual to have Max $ amount by Carrie Good Afternoon, Currently I have this formula: =SUM(B6:G6)*(0.173) But I don't want the caluculation to exceed $711.03 Help ( 1 2)	October 26th, 2009 11:01 PM by Gord Dibben	14	200
Hyperlink from html to specific worksheet by WayneO We have html files with links in them that open an Excel document and goes to a specific worksheet. Since upgrading to Office 2007 we now find that the link...	October 26th, 2009 10:46 PM by WayneO	0	110
Linking Zip codes and Cities by Lycean I'm trying to create a customer database. I want to be able to type the city and have it auto-fill the next cell with the ZIP code. I don't know much about...	October 26th, 2009 09:41 PM by James Silverton[_4_]	4	111
Excel Column labels show as numbers by mrudnet I am working in Excel 2007 and suddenly the columns are showing as numbers and not the usual letters (A, B, C...). How do I change this back? Thanks.	October 26th, 2009 09:34 PM by JBeaucaire[_133_]	2	131

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed