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
June 4th, 2010 10:42 AM
by James Go to last post
0 388
Dave... try to open this link...so many information about creating drop down list http://www.contextures.com/xlDataVal01.html reza "Dave" wrote: Hi
June 4th, 2010 09:49 AM
by reza Go to last post
0 365
Filtering data based on historical values by Jim
Hello everyone, I am trying to sort a list of temperatures to analyze a chillers operation. The chiller turns on when the outside air temperature is 80, and...
June 4th, 2010 09:31 AM
by steve Go to last post
1 373
automatic sheet selection by swiftcode
Hi all, I need some help on the following. Assuming on sheet 1 in a workbook, in column A2 to A30, i have the sheet names listed in each cell, how am i able...
June 4th, 2010 09:02 AM
by swiftcode Go to last post
2 357
June 4th, 2010 08:51 AM
by steve Go to last post
4 473
Excel inserting slow by rossoneris
On a complete new windows 7 64 bit pc with office 2007, it is running extremly slow when opening documents or inserting normal pictures. When I go to excel,...
June 4th, 2010 07:27 AM
by rossoneris Go to last post
0 379
Shutting down the Discussion groups by מיכאל (מיקי) אבידן
A few days a go I read, in one of the previous pages, that the the DG are about to be shut down and we moving to the new Excel Forums. Was that a false alert...
June 4th, 2010 07:01 AM
by David Biddulph Go to last post
7 448
Can text too long for cell NOT carry over into cells after it? by Greg
I have a cell with a full sentence in it. The cell is too small for that sentence so of course it carries over the cells to the right of it to display the...
June 4th, 2010 06:24 AM
by Jacob Skaria Go to last post
1 434
Average time by DSN
I have a list of mm:ss times in a column. I want to find the average of the list. I have tried different things, but I keep getting 'Divide by zero error'...
June 4th, 2010 06:24 AM
by Jacob Skaria Go to last post
1 410
Copy and insert multipel rows after each row of data by myork
I need to copy a row and insert it 19 times in the rows below it, for 100+ rows.
June 4th, 2010 06:24 AM
by Jacob Skaria Go to last post
2 515
Coloring cells by OldManEd
I have a column of numbers. Some are positive and others are negative. I would like to color "red" the cell with negative numbers and 'green' the positive...
June 4th, 2010 05:44 AM
by Black Iccy Go to last post
8 453
Can't Edit Cell Comments by Paul Calcagno
I'm running Vista Home Premium SP2, 2 GB RAM, Firefox, Spyware Doctor, MBAM, SAS and CCleaner, Office 2007. All of a sudden only one (of many) worksheets...
June 4th, 2010 04:30 AM
by Paul Calcagno Go to last post
1 345
excel password by Sang-Wook Chu
I forgot the password for my excel file. I have tried some programs such as Accent Excel password recovery, advance office password recovery. Neither did...
June 4th, 2010 03:21 AM
by edelic Go to last post
4 449
divide a string words separated by (number) by ferde
I would like to have the data that is in one cell parsed into two cells like in the example below. The data is always separated by a consecutive whole...
June 4th, 2010 01:33 AM
by ferde Go to last post
3 351
Remove columns with all zeros by Nora_GG[_2_]
How can I remove columns that contain all zeros? Is there a macro? I craeted a sumif formula to flag columns subtotaling zero but I need a method to remove...
(Multi-page thread 1 2)
June 4th, 2010 12:49 AM
by Nora_GG[_2_] Go to last post
11 596
How can I update macro to delete zero amount columns? by Nora_GG[_2_]
I have a spreadsheet that contains columns with text (such as name, job title, hire date, etc.) and several columns with amounts. I want to delete the...
June 4th, 2010 12:35 AM
by Nora_GG[_2_] Go to last post
2 435
Increment Value By 1 Each Time Spreadsheet is Opened by The Project Master
I am creating a purchase requisition form in Excel and when users open the spreadsheet I want the requisition # incremented by 1 so we have unique requisition...
June 4th, 2010 12:34 AM
by Don Guillett[_2_] Go to last post
2 412
VBA sort range with certain fontcolor by Jack Sons[_2_]
Hi all, Ik column K there will be a continuous range of which all cells have a certain fontcolor, the font color code is, say, 5. The range can be 1 cell up...
June 3rd, 2010 11:32 PM
by Jack Sons Go to last post
5 403
How do i copy data from one sheet to another, to include the footer and header. I created a log for work. I need 20 of them to be able to fit everyones name...
June 3rd, 2010 11:31 PM
by Gord Dibben Go to last post
3 400
Auto Row Height with Wrapped Text in Merged Cells Problem by Rick Cl.
I can't get my spreadsheet to automatically change the row height when using text wrapping IF I'm working with several merged cells in adjacent columns. It...
June 3rd, 2010 11:21 PM
by Gord Dibben Go to last post
3 1,123
Post New Thread

Display Options
Showing threads 101 to 120 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 06:49 AM.

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