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
Change default text color without reformatting the sheet. by Monorail Central
I have a premade worksheet that I want to send to others so they may add and edit information. I need the text they type to appear in a pre-determined color...
January 15th, 2009 01:28 AM
by Gord Dibben Go to last post
1 88
matching items on a range by James
So I have tried this a few ways but with no success, I am not sure if a formula can do what I am asking for but here is my example. (A), (B) (C) ......
January 15th, 2009 01:28 AM
by smartin Go to last post
1 79
Show all values in first column of Pivot Table by bmac
Hello, I have a pivot table with columns A through M and rows 1 - 14,000 I have some duplicate values in coumn A. The values in columns B through M are not...
January 15th, 2009 01:23 AM
by smartin Go to last post
2 69
How to find a worksheet by its name in a workbook? by Alchemist
Dear All: I have a workbook where every day about 10 new sheets are added. After I open the workbook how I can find a specific sheet by using the name on the...
January 15th, 2009 01:17 AM
by Gary''s Student Go to last post
2 59
Header Bars by marymack15
The alpha bar across the top and the number bar down the side are showing in about a 2 Font size. How do I make these bars larger, without changing the font...
January 15th, 2009 01:14 AM
by Bernie Deitrick Go to last post
1 57
Average formula multiple worksheets by JAbels001
Alright... This has been stumping me for awhile and I dont know if there is an easy way to do this, but I'm hoping someone smarter than me could help. I have...
January 15th, 2009 01:12 AM
by Bernie Deitrick Go to last post
1 69
formula vs value by saraua
I wrote a vlookup formula in a cell and all i get is the formula, not the value of the formula. How can I get the value to populate?
January 15th, 2009 01:04 AM
by Gord Dibben Go to last post
3 61
Footers by Pat
I have a spreadsheet which has been used for many years by several different people who have each applied their own particular "footer" to the spreadsheet. ...
January 15th, 2009 01:02 AM
by Gord Dibben Go to last post
1 106
Excel 2003 by Alefiah
I have a user who has got a couple of embedded drop down list boxes on her spreadsheet, the problem is she can hardly read the entries. Is there a way to...
January 15th, 2009 12:37 AM
by Gord Dibben Go to last post
3 135
to make the digit 10 into the text ten by Tbarbee708
can i type in a numer (ie 10) in A1 and have A2 fill in automatically the written "ten"? etc -- Tbarbee708
January 15th, 2009 12:28 AM
by Gord Dibben Go to last post
5 58
Auto-sort worksheet by date in column A by avshook
I would like to have my worksheet sort itself chronologically by date when I enter a new date in column A. The dates will be entered in a random order on...
January 15th, 2009 12:08 AM
by Gord Dibben Go to last post
3 77
Rounding to the nearest cent...currency values by Mr Mark
I am having trouble getting either a product or sum to round to the nearest cent. How do I do this? Example 6015.54x1.4=8421.76, However when I do this in...
January 14th, 2009 10:35 PM
by Mr Mark Go to last post
3 82
formating number with place holder by Royce
I have numbers on sheet some single digit and some 2-digit. I am trying to autoformat so that all the single digit have a 0 precursor. Ex. 1 would yield...
January 14th, 2009 10:33 PM
by David Biddulph Go to last post
3 65
Cell reference to a filename by Stevep4
I am putting together a data sheet for each of over 500 products. There is great benefit to all if the data sheet uses the latest information from source,...
(Multi-page thread 1 2)
January 14th, 2009 10:30 PM
by Dave Peterson Go to last post
10 102
conditional formula keeps changing by nbarr
so i have created this sheet to track recruitment calls. in it, i have created a conditional formula that enters the date and time into a cell when another...
January 14th, 2009 10:21 PM
by nbarr Go to last post
2 118
splitting text and calculating time by Kajuliano
Hi-- I'm new to excel and here is my issue: I have two columns of data, the first column has both the date (year-month-date) and time (in hours, minutes,...
January 14th, 2009 10:00 PM
by Mike H Go to last post
8 81
Automatic Date Increase by 12 Months by Steve 084
I am a fairly new user. In field A1 I have the date 12/1/08. Is there a formula that would automatically add "12" months to A1 and place the results in A2...
January 14th, 2009 09:50 PM
by Steve 084[_2_] Go to last post
2 70
Wher is my Camera Button in Excel 2007? by wx4usa
In my older version of Excel I had a small Camera/Picture Icon. Where is it in 2007 ?
January 14th, 2009 09:44 PM
by Jeff Jensen Go to last post
8 126
Prevent paste from re-formatting cell by BMac
worksheet is protected and all cells except 4 are locked. Even though users are not able to change formatting of these cells directly, I just realized that...
January 14th, 2009 09:42 PM
by JE McGimpsey Go to last post
4 74
Moving Mutli-Column Multiple-Selected Listbox items up or down by MP
Currently using this code to move single mult-colum list box items up.. How do I modify the code to move muliple selected items...
January 14th, 2009 09:34 PM
by MP Go to last post
0 65
Post New Thread


Display Options
Showing threads 28081 to 28100 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 10:14 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.