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
Why can't I view the gridlines of a certain column by Danielle_85
Guys I don't know how to view the grid lines of Column J, the remaining columns are OK...I tried looking it up on the tools/options/view and unchecked and...
December 27th, 2009 11:56 AM
by Mike H Go to last post
1 77
Pivot Table 2007 display field only in Grand Total by M Masalha[_2_]
Dear Excel experts, I have a Pivot Table (Excel 2007). As an example, the table consists of two Colum Labels (Expense 1 and Expense 2). Values under the...
December 27th, 2009 05:24 AM
by M Masalha[_2_] Go to last post
0 84
JB Bates' Runtime Error 1004 problem by Ken Johnson
I am using Google Groups to view this forum and my three attempts at responding to this...
December 26th, 2009 11:32 PM
by Ken Johnson Go to last post
0 125
Protect & Hide Sheet by Panchi[_3_]
Hi.. I have a few questions : 1. I have a sheet which has data in rows. How can I have the row highlighted in red if a particular cell A3 is blank for...
December 26th, 2009 10:17 PM
by trip_to_tokyo[_3_] Go to last post
4 73
Array Substitution Based on Drop Down List by Royce Edwards
I have created a drop down list in excel cell A1 which contains a validated list from cells D1 through D3. The values of D1 through D3 are cat, puppy, and...
December 26th, 2009 10:13 PM
by T. Valko Go to last post
1 69
Deleting duplicates - kind of by Tamara
My boss had me merge together a ton of data. Group Name, Renewal Month, Broker Name, Broker Phone, Address, Address 2, City, State, County, Zip,...
December 26th, 2009 08:23 PM
by Herbert Seidenberg Go to last post
7 164
make formula look at diff sheet by wx4usa
I have this formula that works great if the data is on the...
December 26th, 2009 08:07 PM
by T. Valko Go to last post
5 86
I need help with Excel formula by antoinette
I need help with Excel formula (first one is correct but I don't know how to add second formula)? =IF('1'!W16="($E202000000,0,IF($E20100… =""AB8",'1'!W16)...
December 26th, 2009 07:03 PM
by Ron Rosenfeld Go to last post
1 72
How to open Two copies of Excel under Win7 by Roger
I have two different workbooks I would like to view at the same time. I would also like to copy & paste cels from one spreadsheet to the other. Under Winxp...
December 26th, 2009 05:52 PM
by TopQuark Go to last post
6 106
uppercase by oldLearner57
hi community, how can i force a cell entry to have the text change to Uppercase? any guidance much appreciated 10s community :) --
December 26th, 2009 05:30 PM
by Otto Moehrbach[_2_] Go to last post
4 74
Moving range? by wx4usa
I have Months in B1:M1. Dollars in B2:M2 I need a formula to return the sum dollars of a range of consecutive months that is variable such as.....start month...
December 26th, 2009 05:28 PM
by wx4usa Go to last post
7 96
How does one Delete an Entire Workbook as opposed to a Worksheet -- Don
December 26th, 2009 04:45 PM
by Don Guillett Go to last post
4 86
Number grids by BOB43
Hello, I use EXCEL 2003. I'm trying to apportion some costs to optimise returns. I have managed to work out how to do it for 2 or 3 variables and use a grid...
December 26th, 2009 04:21 PM
by Lars-Åke Aspelin Go to last post
1 73
Hide Unhide Buttons by Microsoft Communities
This is a two fold question: Q1 I have a situation where a button resides in 2 of 4 columns that hidden until needed. When I hide the columns it appears that...
December 26th, 2009 04:18 PM
by Don Guillett Go to last post
4 79
Copy & Paste by Jaleel
Hi, I am using Excel 2003. In my one Excel file of 23,186 kb size, if I copy from one sheet and try to paste into another sheet, nothing happens. Whereas...
December 26th, 2009 01:50 PM
by מיכאל (מיקי) אבידן Go to last post
4 96
Macro is not working properly by Sherees
-- Life isa journey not a destination
December 26th, 2009 10:18 AM
by FloMM2 Go to last post
5 116
TEXT(F2 "0,0") displays 1 as 01, & how to bold and underline in TE by Gary
I understand the TEXT function, however when I format it as TEXT(F19,"0,0"), I get 1,000, displayed correctly. Also 10 thru 999 displays correctly, but 1...
December 25th, 2009 10:36 PM
by Ron Rosenfeld Go to last post
3 99
Excel is not counting by Sherees
merry x'mas In excel 2003, i entered a number in a column and dragged down the rows to count the consecutive numbers automatically, but it was just copying...
December 25th, 2009 06:39 PM
by Gary Keramidas Go to last post
3 74
Vertical Indent in Excel 2002 by Excel
Please help me to create Vertical Indent in Excel 2000 or 2002 because the border line are very near to the text given in a table, it looks very congested in...
December 25th, 2009 05:23 PM
by Gord Dibben Go to last post
1 74
Macro (password) by Mike
I have this macro now i would like to set this cell with a password is this possible Private Sub Workbook_SheetChange(ByVal Sh As Object, _ ByVal Target As...
December 25th, 2009 02:25 PM
by Dave Peterson Go to last post
6 80
Post New Thread

Display Options
Showing threads 8001 to 8020 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:02 PM.

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