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 Replies Views Reverse Sort Order
Drop Down Calendar by BJ Snyder
How can I insert a drop down calendar to a cell in a worksheet?
June 2nd, 2010 06:03 PM
by Originalgoth Go to last post
4 1,137
Making Excel generate Access-Like Reports by VJ7777
Please forgive me if I don't use proper Newsgroup protocol. This is my first time. I have developed a comprehensive dealership system using Excel. I...
(Multi-page thread 1 2)
September 12th, 2004 05:48 AM
by JulieD Go to last post
15 1,137
Formula ? by TQ
Hi, anyone who know the solution below ? Start Date End Date 01.01.10~31.12.10 01.01,11~31.12.11 1)01/10/09 31/01/10 ...
June 6th, 2010 04:30 PM
by TQ Go to last post
4 1,137
If word from list selected adjoining cell to downfill with a code by Mon
If a word is selected from a drop-down list, is there a formula I can use to colour code the adjoining cell?
June 3rd, 2010 05:30 AM
by Jacob Skaria Go to last post
1 1,133
Auto Expanding Merged Cells by Frank Kabel
Hi this is one of several merge cell drawbacks. No real workaround available. Try avoiding merged cells! -- Regards Frank Kabel Frankfurt, Germany
June 11th, 2004 10:38 PM
by Gord Dibben Go to last post
2 1,124
Text to Columns by Emece
Hi. I have a column where I have names and surnames. I want to put name in one column and surname in anoter column. In order to do this, I use Text to...
June 2nd, 2010 07:10 PM
by Emece Go to last post
5 1,119
re; Worksheet_SelectionChange goes cold by Rob
Hi Bob, I thought someone might suggest this but I feel the whole workbook will need to be evaluated as it's turned into a rather complicated nightmare. The...
June 12th, 2004 01:43 AM
by Rob Go to last post
1 1,118
Filtered data range reference is too complex by Tony7659
I am trying to copy/paste the filtered (subtotals) on my worksheet of about 17,000 rows. I do this every week. Unfortunately, I am getting the following...
May 20th, 2010 06:25 PM
by Donberti Go to last post
6 1,118
remove all duplicates? by snow
Hey. I have office 2003. Was wondering how do you remove all duplicates? I have a column with the names of the employees, and another column with the names...
June 2nd, 2010 09:54 AM
by Ms-Exl-Learner Go to last post
3 1,117
corrupted formula in protected worksheet by Tom-S[_2_]
Is there any way (in Excel 2003) in which a formula in a locked cell of a password protected worksheet can end up corrupted, without the sheet having first...
(Multi-page thread 1 2 3)
May 29th, 2010 04:29 PM
by Dave Peterson Go to last post
21 1,114
Conditional Formating by Going Crazy with excel[_2_]
I have developed a rule for a column of data. =$ak$7:$ak$11 =$ak$4:$ak$6 I want to repeat this same rule to adjacent columns, AL thru AS. Then I want to repeat...
June 4th, 2010 01:42 PM
by Jackpot Go to last post
9 1,110
January 9th, 2008 06:21 AM
by Jon Peltier Go to last post
1 1,110
wpexcel by questions123
when i open excel. WPEXCEL opens up first. How do I stop that from happening? Thanks
July 13th, 2006 03:42 PM
by Gord Dibben Go to last post
3 1,107
Text won't align at bottom of cells in Excel 2007. by BillCT1984
Text aligns in middle of cells even when bottom alignment is chosen in Excel 2007. How can I get text to align on the bottom of the cell?
February 19th, 2010 08:19 PM
by Jacob Skaria Go to last post
1 1,103
Formula omits adjacent cells by Ali
Hi there I have a spreadsheet with a SUM formula in Column k. Example K3 formula is =Sum(D3:I3) I clicked and dragged this formula all the way down to K...
March 22nd, 2009 07:19 AM
by Ali Go to last post
2 1,102
subtotaling pages in excel by Amethyst
I need to know how to create subtotals for individual pages in excel. The user has data each month consisting of hundereds of rows. Is it possible to have...
December 3rd, 2006 02:58 AM
by Amethyst Go to last post
3 1,102
summing based on auto filter by Art
I have a spreadsheet with several hundred rows and many columns. The formula in column "C" sums values for all columns from "D" through the last column for...
June 13th, 2004 04:19 PM
by JE McGimpsey Go to last post
2 1,100
how do we get 2003 .xlb toolbars and custom macros to show in 07 by bigdeal
I have custom macros that are saved in an .xls file under the XLStart/ folder in Excel 2003. These macros are referenced by an Excel11.xlb file that holds...
June 6th, 2010 01:24 AM
by Dave Peterson Go to last post
1 1,098
Group Dates from SQL Query by wjvii
I have the results of a SQL datasource providing the data for a pivot table. Several of the fields are dates however I cannot group them like they were...
March 23rd, 2007 12:52 AM
by Nick Hodge Go to last post
1 1,096
"1235" appears as "One thousand two hundred thirty five" by H. Kan
please i want to know how i convert number to text in excel datasheet or access for example : 1235.75 one thousand two hundred thirty five and 75/100 thank...
(Multi-page thread 1 2)
December 8th, 2006 08:56 PM
by Bernard Liengme Go to last post
11 1,096
Post New Thread


Display Options
Showing threads 161 to 180 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 09:36 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.