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
PivotTable Title by NonTechie
I have Excel 2007. I have a PivotTable and want to have a title for it. When I change "Data" to the title I want, it truncates the title in that first cell....
November 13th, 2009 12:56 AM
by NonTechie Go to last post
2 112
I need to creat a pop up window when I open an excel sheet. by Strugling
I need to get a pop up window, with message and pictures, to open when I open an excel sheet. p.s. not advanced user.
November 13th, 2009 12:54 AM
by Gord Dibben Go to last post
3 136
Scroll Lock key to hold cell and return to it by ManhattanRebel
Once I use scroll lock key to hold a cell, what key do I use to return to that spot?
November 13th, 2009 12:48 AM
by ManhattanRebel Go to last post
2 147
Open files in seperate instance by Rick
I want to set Excel to open files in a new instance. For example, if I double click two xlsx files in a folder and then double-click an xls file attached to...
November 13th, 2009 12:13 AM
by Rick Go to last post
0 117
Autofill question by Gor_yee
Hi there...I need a VBA script that I can use to autofill down a column...so if row a5 had a heading of "happy" and then z5 had a heading of sad... I need that...
November 12th, 2009 11:53 PM
by Gord Dibben Go to last post
2 98
IF Statement in Excel 07 by CandiC
In Excel 2007, I have a dropdown box that contains the names of the states, Iowa, Illinio or exempt depending on where the work is performed in cell C125. I...
November 12th, 2009 11:00 PM
by Per Jessen[_2_] Go to last post
1 102
divide by zero error by susancca
getting the divide by zero error with this formula =IF(F175=0,0,+F175/L155) F175=sum of cells equaling 4 L155=sum of cells equaling 0 any help?
November 12th, 2009 10:04 PM
by susancca Go to last post
5 87
Data Validation using dependency logic by maitri
I would like to be able to limit the available options in a drop down list dependant on the selection made in the previous column. Specifically I have 4...
November 12th, 2009 09:57 PM
by Luke M Go to last post
1 101
Concatenate formula by Bricky
I'm trying to get a formula using concatenate that will identify numbers in a row 3 (4&5) and returning the name of the column above into one cell. Big ...
November 12th, 2009 09:53 PM
by Bricky Go to last post
2 88
copying conditional formats by Ron
I've created a conditional format that colors red cell A1 if the value of cell A1 is less than cell B1. Next, I copied this format into the cells A2:A100. ...
November 12th, 2009 09:01 PM
by T. Valko Go to last post
1 76
Return Column match by Charp
I need to return data from a specific column within multiple columns. For example, I would like to return data from the Mar column by row. Description Jan ...
November 12th, 2009 08:55 PM
by T. Valko Go to last post
1 104
Linking Password workbooks by debinnyc
I have tried to read some of the topics on the subject, but I can't figure out if there is a way to update a master spreadsheet that has links to password...
November 12th, 2009 07:49 PM
by Dave Peterson Go to last post
1 127
change a positive number to negative by MICHALK
How to change a positive number to negative?
(Multi-page thread 1 2)
November 12th, 2009 07:22 PM
by MICHALK Go to last post
16 142
manage tags for microsoft office 2007 by jing.liang
Hi, I have a question about the new "tag" property in Microsoft office 2007. I am wondering whether I can create a nested "tag", for example:...
November 12th, 2009 07:02 PM
by jing.liang Go to last post
0 72
Preformatting Excel Prior to Opening Spreadsheet by Matt
We've got a program that imports data in a CSV format into a brand new Excel spreadsheet, some of the data contains social security numbers which often begin...
November 12th, 2009 07:02 PM
by Jacob Skaria Go to last post
1 126
conditional formatting entire column referencing data from other c by Jamie
I have 2 columns of dates - G and I. I want the cell in column I to conditionally format when the date in Column G is later than the date in Column I. I...
November 12th, 2009 06:43 PM
by David Biddulph Go to last post
2 84
Cell reference by sc
On the below formula I would like to count if the data in A6 is contained in A7 where A7 may have more data. =COUNTIFS(A6,"=" & A7) Specifically, A6 may be...
November 12th, 2009 06:39 PM
by sc Go to last post
3 85
Excel 2003 had a function to "SumByColor" -- it's not in 2007? by Becky
Excel 2003 had a function to "SumByColor", I don't see that function in Office 2007. Does anyone know a replacement, or how to do the same type of thing?
November 12th, 2009 06:35 PM
by Jacob Skaria Go to last post
3 95
Quickbooks export to Excel 2003 by Mike2010
Hello, I use Office 2003 on my computer. I recently downloaded the Office 2007 trial. After a few days, I used the add/remove programs from the control...
November 12th, 2009 06:00 PM
by Mike2010 Go to last post
0 98
Keycode description creator by Beeatrice
I have a feed of approximately 2000 keys. Each key has 4 positions. Each numeric position within the key represents different criteria. Please take a look...
November 12th, 2009 06:00 PM
by Beeatrice Go to last post
2 104
Post New Thread


Display Options
Showing threads 10081 to 10100 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 12:55 AM.


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