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
data collection by driller
Hi again, thanks in advance.. In Sheet1 (A2 ~ A1000) i have a master list of names. In 6 other sheets (with varying sheet name) i have a list of concatenated...
October 13th, 2009 01:04 AM
by B. R.Ramachandran Go to last post
1 106
Copying cell formulas by D.Robison
Excel 2003 ... I have a cell formula for sheet 2 of an excel spreadsheet that is for row 1 "=Cu!A1+Cu!A2+Cu!B1+Cu!B2", where A1, A2, B1 & B2 are numbers from...
October 13th, 2009 12:44 AM
by D.Robison Go to last post
0 152
Formatting question by Texas10
When linking to other workbooks, is there a way to link the formatting of a cell with it?? For example, I have linked cells that are shaded on a sheet in a...
October 13th, 2009 12:12 AM
by Texas10 Go to last post
3 145
COUNTIFS using an array, but a continual -1 reference by Anthony
I have the current working formula: {=COUNTIFS(TRIP!$A$2:TRIP!$A$65536,D$16,TRIP!$B$2:TRIP!$B$65536,"5")} This works tremendously, however I need to add one...
October 12th, 2009 11:42 PM
by T. Valko Go to last post
1 124
Default version of Excel by clr
Hi All........ I have several versions of Excel on my computer at work and each time I get a new higher version number....it seems to automatically become...
October 12th, 2009 10:36 PM
by clr Go to last post
6 186
Create a shortcut for repetitive text by Deej Hernandez[_2_]
I have Office 2007 Home Edition running on a laptop with Vista Home Premium. I run a football pool every season and would like to know if there is any way...
October 12th, 2009 10:02 PM
by Dave Peterson Go to last post
3 127
emailed spreadsheets requiring a password by 2007User
I'm a professor using the software from our campus agreement. 2007 spreadsheets are coming in as needing a password to open. Tried saving and opeing from...
October 12th, 2009 09:25 PM
by Joel Go to last post
1 137
increase number of items shown in drop down list? by kojaks43
Using Excel 2007 - Home edition. Created a list and placed drop down using data validation. The drop down window shows some of the entries with a scroll bar. ...
(Multi-page thread 1 2)
October 12th, 2009 09:17 PM
by MJH Go to last post
11 270
How to cut off characters in a text column by abc[_9_]
Hello In my Excel file there is a column with text data where the data consist of lots of characters. Only n characters in the column for each record are...
October 12th, 2009 07:40 PM
by abc[_9_] Go to last post
3 120
Parameter Query by Lee
I seem to be hitting a limit in the number of parameters Excel takes in getting data. The query in MS Query does return records alright with four parameters,...
October 12th, 2009 07:38 PM
by Lee Go to last post
4 129
Excel 2007 and "owner files" by Marc
Hi all, I understand Excel 2007 now creates "owner files" (starting with ~$) for xslx files and not for xls files. My problem is that it seems impossible to...
October 12th, 2009 07:25 PM
by David Biddulph Go to last post
1 138
fill any random cell in a column and block all other cells by SK
Hi, I am using the latest version of Microsoft excel (.xlsx). In a column, I just want one cell to be filled (at any time) and rest as locked; but that cell...
October 12th, 2009 07:20 PM
by Jacob Skaria Go to last post
5 283
parameters by DavidC
When I edit a query and insert parameters, I cannot save teh query because I get the message: "Parameters are not allowed in queries that cannot be displayed...
October 12th, 2009 06:48 PM
by Joel Go to last post
3 142
Worksheet Change Event - copy cell to another sheet by dhstein
I'm coding a Worksheet Change event to trigger when a cell changes. It works well so far. The problem is I want to copy a cell from this worksheet to...
October 12th, 2009 06:35 PM
by Dave Peterson Go to last post
2 103
2007 Excel and Dreamweaver Web pages by jmsvbit
When I upload an Excel workbook to a site created with Dreamweaver, it loads without problems. When I click the link to the workbook, Excel opens...
October 12th, 2009 06:00 PM
by jmsvbit Go to last post
0 118
Simple calc not working as expected - what am I missing? by MarianneS40
This is probably something so simple, but I can't figure it out, can someone help? I'm trying to deduct a range of values from the first value in the row:...
October 12th, 2009 05:03 PM
by MarianneS40 Go to last post
7 142
PIVOT - value defaults - for Excel 2007 by mgville
FYI- Excel 2007 users- If you're like me and use pivots with tons of values that need calculations other than the default, I found that you can change your...
October 12th, 2009 04:44 PM
by mgville Go to last post
0 107
Can't re-size worksheet by basils57
For some reason when I open one particular Excel workbook it opens at about 50% size and without the Excel logo to the left of the heading and without the...
October 12th, 2009 04:29 PM
by basils57 Go to last post
2 207
Ghost in my VLOOKUP by WildWill
Wow, I have setup a VLOOKUP to search through a tabel of 7 columns x about 15 rows, and to match a string of Alpha-Numeric values, e.g. "BXZ678GP" - but I am...
October 12th, 2009 04:28 PM
by Jacob Skaria Go to last post
1 100
Cannot save macro buttons in QAT by OssieMac
When xl2007 was introduced, one could add buttons to the QAT to run macros and save them with the workbook. Now when that is done, the buttons only remain...
October 12th, 2009 03:49 PM
by Ron de Bruin Go to last post
1 203
Post New Thread


Display Options
Showing threads 11841 to 11860 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 03:04 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.