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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Possible to get a time/date when a cell is written? by Twoflower
Is it possible to get a date in a cell when another specific cell is "filled, written, populated (not empty)"? If yes, how?
November 11th, 2009 08:44 PM
by CLR Go to last post
3 215
In excel, I can't get my right margin to zero, It goes to (.51) by jnj2501
In excel, I set my right and left margins to zero for printing in landscape mode. However, the right margin always resets itself to (.51). How do I get both...
November 11th, 2009 08:42 PM
by Dave Peterson Go to last post
2 247
3-d reference is not updating by TigerMO
I copied a range of cells from Worksheet2 and went to Worksheet1 where I used Paste Special, then clicked on Paste Link. The cell formulas now show a cell...
November 11th, 2009 08:41 PM
by Dave Peterson Go to last post
1 252
Automatically color merged cells by Rick
Using Excel '07, I'm trying to automatically highlight a list of vertically merged cells the same color as their unmerged rows next to them. For...
November 11th, 2009 08:25 PM
by Dave Peterson Go to last post
1 236
Date reverts to numeric format by ManhattanRebel
I have a date in this format May 1, 2009. I’d like to keep it in that format, but when I concaternate it with another cell, the date converts to a numeric...
November 11th, 2009 08:18 PM
by ManhattanRebel Go to last post
3 246
excel formula won't copy down by Janet T
=sum(c1-a2+b2). Just a simple formula for keeping track of cks for bank statement. Have used it for well over a year with MSC Office Home and Student, now...
November 11th, 2009 07:46 PM
by Janet T[_2_] Go to last post
7 250
Copy Problem with 2007 Conditional Format by Andy
The link below will let you see what I am doing. I have created the formula in F3 based upon the values for D3 and E3, but when I copy it down through the...
November 11th, 2009 07:38 PM
by David Biddulph Go to last post
2 202
Numbers in a formula! by Shadowdw
This may sound daft but i'm baffled! I have an IF formula shown below: =IF(T4= ,"Level 4","") in the large gap above I would like to place the...
November 11th, 2009 07:31 PM
by Rick Rothstein[_2_] Go to last post
4 198
Saving in new file format by moon
Hi, I just upgraded from Excel 2003 to Excel 2007. When I saved an Excel document written with Excel 2003, I got the following Compatibility Checker...
November 11th, 2009 07:12 PM
by Ron de Bruin Go to last post
2 349
Addition based on left column by Marc
How can I add the column on the right based on entries to the left? I want to add up all Zuari Inds., Zydec Gentech, Zydus Wellness, Zylog Systems. Zuari...
November 11th, 2009 06:56 PM
by T. Valko Go to last post
4 236
Hide/Show details in an Outline Group by JimAA
I'm trying to create a simple two column cost summary in Excel 2007. Column A has about 700 rows of Cost Item descriptions and Column B is where I want to...
November 11th, 2009 06:56 PM
by JimAA Go to last post
0 234
How can I alphabetize data excluding words like "a" and "the"? by Faith
I'm cataloging a list of movies, and I'd like to be able to alphabetize the titles ignoring words like "a" and "the." Is this possible?
November 11th, 2009 06:50 PM
by Peo Sjoblom[_3_] Go to last post
6 187
How to make an entire column of web addresses into hyperlinks? by mollyc
Im trying to figure out how to hyperlink an entire column of websites at the same time.
November 11th, 2009 06:49 PM
by CLR Go to last post
2 215
Truncating a VIN by lputnam
I have an excel spreadsheet with several hundred VINs and want to truncate to show only the LAST 6 digits. What formula do I use that will look at the cell...
November 11th, 2009 06:28 PM
by CLR Go to last post
3 235
Finding duplicates within a column by Cynthia Amrit
I need to find duplicates within a column. I want it to say what is the duplicate and the non duplicate to blank in column B. A B Dog ...
November 11th, 2009 05:56 PM
by Madwitch Go to last post
3 180
FAO VBA Code MVP's! by Buyone
Hello, I found and borrowed this macro from Dave Peterson. It works, but i need to add in a couple of things to make my life that one bit easier. I need to...
November 11th, 2009 05:34 PM
by Buyone Go to last post
4 202
How to combine more than one condition for CONDITIONAL FORMATTING by Asoka Walpitagama - Brandix College IT
A B C 1 OTT Supplier availability 2 10-Nov BT 9-Nov 3 10-Nov CD 9-Nov 4 11-Nov BT 16-Nov 5 ...
November 11th, 2009 05:10 PM
by Fred Smith[_4_] Go to last post
1 217
tools options view window options by Joe[_45_]
If I bring up a shared workbook and when I look at the windows options under tools, options, view, the box is checked and gray - you CAN"T change the box....
November 11th, 2009 05:08 PM
by jlclyde Go to last post
1 188
Why are my header & footer overlapping text? by July Girl
The Header is printing within the lettered rows above my columns and the footer is printing inside the text itself. I am using excel for my chart. Please...
November 11th, 2009 04:58 PM
by Gord Dibben Go to last post
1 188
Excel 2007 - How to create a routing list, one after another? by Gene
Can this be done in Excel 2007 or even Microsoft Outlook? this was available in Excel 2003.
November 11th, 2009 04:57 PM
by jlclyde Go to last post
1 239
Post New Thread


Display Options
Showing threads 10161 to 10180 of 139764
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 11:39 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.