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
Loan Calculator for more than 30 years by Ray_Johnson
I'm using the Loan Calculator (Amortization Schedule) that comes with Microsoft Excel (I'm running Excel XP). I need to change it so that it will allow more...
March 30th, 2005 08:01 PM
by Ray_Johnson Go to last post
1 144
how do i seperate data from one column into two seperate ones in . by Nikki
how would i seperate the data below (which is currently in one column) into two seperate columns based on date/time? 2/16/2005 1:09:09 PM
March 30th, 2005 08:31 PM
by C&S Go to last post
2 152
data entry from two cells across worksheets by sp-googling
I'm wanting to have cells take the value of the last one updated across worksheets. I've found the code that accomplishs this within one worksheet, but not...
March 30th, 2005 09:07 PM
by sp-googling Go to last post
7 165
Wish to apply "Save Preview Picture" in 300 files. by Jim May
I've created 300 files none of which show in the "preview-screen" when I do a File Open. The setting of course is in the File Properties, Summay Tab (chk box...
March 30th, 2005 09:09 PM
by Carolyn Crandall Go to last post
2 258
How do I copy a link that is in columns to another worksheet down. by Bolynx
How do I paste a link that is in colums to another worksheet down in rows. such as. 4/15/05 4/16/05 4/17/05 40 40 40 4/15/05 40 4/16/05 ...
March 30th, 2005 09:15 PM
by Carole O Go to last post
1 247
long formula obscures cell view by KG
I have a workbook with very long formulas (basically external links to several other workbooks). As a result, when I point to a cell containing such a formula,...
March 30th, 2005 09:30 PM
by Gord Dibben Go to last post
5 123
User name in Footer by Brian Allen - McKEOWN INC.
I'm trying to put the user name in a footer and can't figure it out. I want "This file was prepared by 'username' on &.". But I can't get the username in...
March 30th, 2005 09:57 PM
by Brian Allen - McKEOWN INC. Go to last post
8 119
Capitalizing selected area by J.E
Is the correct verb 'to capitalize' ? :D Anyway, how do I make letters in selected area go CAPS? Its a workbook that is going to be filled up in daily basis...
March 30th, 2005 10:10 PM
by Gord Dibben Go to last post
3 78
Display Worksheet in Excel File by Rowf
I want to Display the worksheet name on the Excel Spreadsheet itself. ie. On Worksheet1, Cell A1 = Worksheet1 How do I do this without having...
March 30th, 2005 10:16 PM
by Gord Dibben Go to last post
2 118
Moving columns into rows by jim314
I'm constantly getting e-mails at work that require me to make a spreadsheet of the names the e-mail was sent to. The text looks something like this (and it's...
March 30th, 2005 10:24 PM
by Trevor Shuttleworth Go to last post
1 187
soft-coding lines in a macro by GJR3599
I am trying to get a macro to find the last line of data (Ctrl+Shift+Down) and then go down one line...this keystroking hard-codes the line i have selected but...
March 30th, 2005 10:28 PM
by Trevor Shuttleworth Go to last post
1 70
Formula to Text to Formula by Bonnie
Hi there! Using E02 on XP. Have zillions of formulas to create and if I can get my template going, it will be much easier. Only problem is this: I used Replace...
(Multi-page thread 1 2)
March 30th, 2005 10:57 PM
by RagDyer Go to last post
13 190
How to sort a column in reverse (right-to-left) by Lady Layla
Can you split the column into 4 seperate columns using data ---text to columns (format all cells as text beforehand so you dont lose leading 0's)? Then Select...
March 30th, 2005 11:11 PM
by retman Go to last post
5 73
sumproduct and even numbered rows by Jack Sons
Hi all, In column C I have amounts (e.g. 2345,89) in even numbered rows beginning with C4 up to C98 and corresponding codenumbers (integers 1 to 46) in...
March 30th, 2005 11:24 PM
by Bill Kuunders Go to last post
6 72
How can I convert an Excel file to someone who doesn't have Excel. by donnythejazz
That's it. I have a large Excel file which I want to send. The receiver doesn't have Excel and can't read the file. He says he can read TXT,DOC,HTML and RTF. I...
March 30th, 2005 11:59 PM
by Dana DeLouis Go to last post
3 117
How do I choose multiple values in an excel drop down box? by Kristy
I'm interested in being able to choose multiple values from a drop down box. I've not found any information available on how to do this.
March 31st, 2005 12:04 AM
by Gord Dibben Go to last post
1 248
Excel opening all files in root of C: when launching by yarbrough2
I have been combating a problem, I have several users who when they open Excel it tries to open all files in the c:\ drive. (i.e. .doc, .log, .bat, etc) I...
March 31st, 2005 12:08 AM
by Gord Dibben Go to last post
1 349
How many items can a pivot table hold? i.e. a worksheet taps out . by j
Does anyone know how much data a pivot table will hold???? I can get it to accept 30,000 items but not 50,000... What are it's constraints?
March 31st, 2005 12:14 AM
by Debra Dalgleish Go to last post
1 92
How do I split a list by every other one in excel? by Lady Layla
Is it a list in 1 column and you need to make it into 2 columns? If so, Download Asap Utilities Add-in and use Advance Transposer -- select 2 columns and let...
March 31st, 2005 12:15 AM
by jont Go to last post
4 118
Create a custom footer for all Excel worksheets at one time... by bigcat
I want to create a custom footer, just once, that could be applied to all worksheets in an Excel workbook. Microsoft Word lets you do this, so why not...
March 31st, 2005 12:15 AM
by Gord Dibben Go to last post
2 283
Post New Thread


Display Options
Showing threads 9841 to 9860 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:39 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.