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
Active Workbook by Kim
Using Excel 2007, I have a macro where I use a workbook, then save as a new named workbook. I want to keep the original workbook open. What code language...
June 1st, 2010 11:33 PM
by Dave Peterson Go to last post
8 316
formula for averages by JNSteiner
I have to compute the last 15 scores and obtain an aveage for Special Olympics entry. I want to be able to have a formula which goes up the column until it...
June 1st, 2010 11:32 PM
by Lars-Åke Aspelin[_4_] Go to last post
1 198
how can we make one constant number to be act as variable by Vimlesh
I mean to say if we have this formula in a cell: =vlookup(A12,A35:j40,4,true) Now i wanna make this 4 to be act as variable and when i drag the cell containg...
June 1st, 2010 11:26 PM
by Gord Dibben Go to last post
3 282
Filling Out Cells Based on Data Validation by Ericc
I have created a drop down list using data validation. What I need to do now is have cells filled out based on the value selected. In this case, the list has...
June 1st, 2010 11:15 PM
by Gord Dibben Go to last post
1 235
Delete rows data moving by njoseph
When I delete a row in excel 2007 the data that is with with the rows below does not move with it. the actual text and color formatting will move, but the...
June 1st, 2010 11:07 PM
by Gord Dibben Go to last post
3 230
w/excel how can I have half a page width differ from bottom by deb
w/excel how can I have half a page width differ from bottom
June 1st, 2010 11:02 PM
by Gord Dibben Go to last post
1 199
Hidding rows when sorting by jodleren
Hi all I have a sheet, where I upload informaton - some rows are hidden (parts already in stock) So, when they sort by some coloumn, it shows all rows, and...
June 1st, 2010 10:51 PM
by Gord Dibben Go to last post
1 235
MATCH returning #N/A by JEB
I'm having MATCH returning #N/A for some items in the list and not for others. I can't figure out why. Here's the...
June 1st, 2010 10:25 PM
by Lars-Åke Aspelin[_4_] Go to last post
3 181
How do you stack 3 words in one cell by Tami Sawyer
I am trying to figure out how to put the text "monthly rental pmnts" all in one cell so that they stack on top of each other. Any suggestions?
June 1st, 2010 10:23 PM
by Dave Peterson Go to last post
3 228
save a file on a CD. by Ralph Walters
I want to save a file on a CD. When I try, I'm told it is not a legal operation ( or something to that effect) and that I must get permission from the...
June 1st, 2010 10:14 PM
by Dave Peterson Go to last post
1 178
Information for Pivot Table by HL
I have a column with the following information: F2=1/3/2010 F3=1/15/2010 F4=2/14/2010 and so on I'm creating a Pivot Table to display this information and...
June 1st, 2010 10:11 PM
by Roger Govier[_8_] Go to last post
3 231
Error created when try to Print Preview or Print by Nadine
When try to print or print preview system is generating an error: "Print titles must be contiguous and complete rows or columns." Used excel for years ever...
June 1st, 2010 10:08 PM
by Nadine Go to last post
0 258
Check data range and return false value if a cell is blank by DavidS
Example Check row A1:R1 and if at least one cell is empty then S1 should indicate "incomplete" otherwise "complete" if every cell in the row has a value
June 1st, 2010 09:12 PM
by Tom-S[_2_] Go to last post
2 253
Excel 2007 format cells to date format by Stefan
Hi got a problem with excel. everytime I open a file the cells are formated in a date format and I have to reformat them. Any suggestions to solve...
June 1st, 2010 09:06 PM
by Stefan Go to last post
0 263
"Save file before closing" by mkilbour
Using Excel 2007 on Windows XP: Monthly I select hundreds of Excel files from Windows Explorer, right click and select Print. It would open an Excel file,...
June 1st, 2010 08:05 PM
by Gary Brown[_6_] Go to last post
2 212
how to turn off standard toolbar, formatting... Microsoft Excel 20 by meaganicole
Hello, I would like to know how to turn off standard toolbar, formatting toolbar and the drawing toolbar? I am using Microsoft Excel 2007. Thanks in...
June 1st, 2010 08:02 PM
by Bob I Go to last post
4 294
Grouping Time in Pivots. by GEM
I have a large DB, this is a small example, Client Date Time 1 5/31/2010 9:32:43 AM 1 5/31/2010 9:34:21 AM 1 5/31/2010 10:51:39 AM 3 5/31/2010 11:10:13...
June 1st, 2010 08:02 PM
by Herbert Seidenberg Go to last post
2 194
how to start a new thread? by Jack Sons[_2_]
Sounds crazy, but I can't post a question in a normal way. I see the button on the upper left side that has the name "New". When I click it there appear...
June 1st, 2010 07:58 PM
by Bob I Go to last post
3 155
Excel not opening documents correctly by s.edwards
I double click an Excel file in windows explorer, Excel starts, but the file doesn't open. Minimize Excel and then maximize and the file is open. Using 2007....
June 1st, 2010 07:55 PM
by Bob I Go to last post
3 220
how to chage existing workbooks background color by jwsmith1967
I was wondering if there is a way to change the background (sheet) color from white to like a light gray so that there is less glare. using excel 2003
June 1st, 2010 07:51 PM
by Tom-S[_2_] Go to last post
1 222
Post New Thread


Display Options
Showing threads 221 to 240 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:55 PM.


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