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 Reverse Sort Order / Thread Starter Last Post Replies Views
'sticky' cell selection by yippeekiay
When I select a cell it cannot be deselected and if i move my mouse it selects all cells from the original. I cannot select a singular cell anywhere else on...
October 29th, 2005 02:11 AM
by David McRitchie Go to last post
2 159
'Substitute' function with wildcards by [email protected]
Can you use wildcards with the substitute function? This is the formula I am using. =SUBSTITUTE(F51,"FY20??","FY2008") However this doesn't work. It seems...
July 22nd, 2009 05:42 PM
by jasontferrell Go to last post
1 120
'Text to Columns' by Text2Col
Hi Folks, I have a question. When I 'Text to Columns' the string '04/19 07:26 04/19 07:28' (which contains dates in MM/DD format), it converts the date to...
June 30th, 2006 01:09 AM
by Text2Col Go to last post
2 102
'The process cannot access the file because it is in use by anothe by CJZ
I receive the following error message when I try to open a Excel document on a network sha 'The process cannot access the file because it is in use by...
November 7th, 2006 06:38 AM
by CJZ Go to last post
1 95
'Time to Fix' Formula by wlln001
I am trying to create a formular which will exclude out of hour support time.. Here's an example Device A fails at 25/08/05 05:20:00 and recovers on 30/08/05...
September 7th, 2005 12:11 PM
by [email protected] Go to last post
1 110
'too many records to complete operation'... by jimmyp
hi i have created a fairly large pivot table and when i come to refresh the data or select specific items i get the error message - 'there are too many...
March 7th, 2006 04:30 PM
by jimmyp Go to last post
1 82
'Track Changes' tool by Huber57
Help! My co-worker has an excel workbook that she has been updating using the "track changes" feature in excel 2002. When she emails it to me, I can't see...
November 2nd, 2006 01:33 AM
by Huber57 Go to last post
0 80
'Trick' to restore original sort order after data modified? by L Welker
Had large excel file. Sorted to combine like type part #. Updated pricing, would like to restore back to original list order? Normally insert a new...
December 23rd, 2009 08:23 PM
by CLR Go to last post
3 116
'underscore' line in '__ / __' not printing ??? by akm
When type '__ / __' (without quotes) the underscore lines show in worksheet but not in print view (and doesnt print). Worked ok a few days ago, but something...
December 11th, 2007 10:36 PM
by Gord Dibben Go to last post
2 92
'Windows in Taskbar' Excel2003 vs 2007 by John
I am running Excel2003 routinely; I am set up with 'Windows in Taskbar' unchecked so that as I click on multiple *.xls files (say in Windows Explorer) only one...
December 2nd, 2008 06:53 PM
by Jim Rech Go to last post
8 225
(1,100.00) hot key ? by SnowLeopard
Is there a shortcut key so that I can get a number to appear as (5,444.00) ? Driving me crazy :)
May 21st, 2008 06:22 PM
by art Go to last post
3 175
(2) Pivot Tables on the Same Sheet to have the same Page Field by Havenstar
Hi, I have (2) pivot tables on the same worksheet. Can I get the page fields to match on both tables when selecting one? Also, will this also work with...
March 11th, 2009 02:24 PM
by Havenstar Go to last post
0 71
(2003) Conditional copying&pasting by Yiannis
Hello, I have a sheet 8 columns wide and 50ish long. Based on a value on col. 2, I'd like to copy the entire row to a new sheet. Do be more specific, I have...
August 5th, 2009 02:39 PM
by Eduardo Go to last post
1 107
(Again) Converting rows to columns by nickr1954
Would appreciate some advice: I am currently downloading some data into an Excel spreadsheet that gives me the following format: Dept.# Account# Month...
January 28th, 2006 02:22 PM
by Domenic Go to last post
4 156
(array?) formula by Jack Sons
Hi all, In col E I have dates or text or nothing, in col G is ABC or RST or dates or text or nothing. and in col H numbers or something else. I need the...
December 29th, 2005 10:24 PM
by Jack Sons Go to last post
2 59
(c) by pkferret
I am trying to enter a form number for a description, 668-W(c), and every time I enter it, the (c) changes to the copyright symbol, and no matter what I do...
(Multi-page thread 1 2)
November 16th, 2006 12:13 AM
by pkferret Go to last post
10 96
(C) and copyright symbol by Mojojo
When I enter (C) into a cell, it appears as the copyright symbol. I don't want the copyright symbol, I just want it to be (C) ! How can I stop this... at...
February 23rd, 2009 06:38 AM
by Shane Devenshire[_3_] Go to last post
3 142
(c) automatically turning into copyright by Scorpvin
how can I enter (c) without excel converting it into a copyright...
February 20th, 2006 11:38 PM
by Dave Peterson Go to last post
4 89
(c) becomes © by XT
y is it that whenever i type (c), it turns to © once i press enter?
March 1st, 2008 04:57 PM
by Roger Govier[_3_] Go to last post
1 66
(C) instead of copyright symbol? by Dave Peterson
You can hit ctrl-z (or edit|undo) to reverse the change. Or you can change your autocorrect list to not correct (c). Tools|Autocorrect options|autocorrect...
December 16th, 2005 03:43 AM
by Ltat42a Go to last post
1 68
Post New Thread


Display Options
Showing threads 1001 to 1020 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:25 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.