A Microsoft Excel forum. ExcelBanter

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 » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Discussion (Misc queries) Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Excel disappearing text in formula bar by Adam Mania
I have this issue: No cell protection of any kind, yet formulas are not appearing in my formula bar. The cursor would appear at the end of the invisible...
February 27th 17 09:34 AM
by Adam Mania Go to last post
0 249
Why this date result? by Terry Pinnell[_4_]
Hopefully self-explanatory illustration: https://dl.dropboxusercontent.com/u/4019461/ExcelFormatVariations.jpg -- Terry, East Grinstead, UK
February 24th 17 09:56 AM
by Terry Pinnell[_4_] Go to last post
1 309
quick annualization by billyk81
Is there any formula built into excel 2016 for quick annualization? Or do I have to go into every cell every month to update the formula for the given month...
February 21st 17 07:02 AM
by Longberry Go to last post
1 385
Formula to find all possible 4 digit combinations using the numbers0,1,2,3,4,5,6,7,8,9 by Danelle Sanchez
Hi, I need to create a formula that will show the results of all possible 4 digit combinations using the numbers 0,1,2,3,4,5,6,7,8,9. I found a similar...
(Multi-page thread 1 2)
11 13,425
Go to a column in a selected row? by Terry Pinnell[_4_]
I have a full row selected and I've opened the Go To dialog. The text cursor is at its left end. What do I now type in the Reference field to select the cell...
February 14th 17 09:23 AM
by GS[_6_] Go to last post
7 618
divide and round up by Pammy
I have a formula: c5/4 I want a formula to divide: c5/4 then round up to a whole number. example: if the answer is 17.3 I want the answer to be 18.
8 18,845
Adding a Trendline Problem by Bob[_19_]
Hello, Using Excel 2007 and W 10 on a PC. Have a very simple graph. Just Blood p reading vs. date. Shows up fine. But no matter what I try or do, I can't...
February 8th 17 06:59 PM
by Claus Busch Go to last post
3 332
Formulae Required by Akash Maheshwari
Hi Team, Require help in creating a formulae. I have data in two Columns: A1 - A10 (Room No) (101, 102, 103, 104) B1 - B10 (Booking Source) (Online, Walkin,...
February 4th 17 12:23 AM
by zvkmpw Go to last post
1 397
How to XML Map Repeating Rows? by DaveLS
I'm trying to map XML to a range of rows but, for some reason, Excel (2007) is only mapping it to the first row of the range. I've created an XML file and...
(Multi-page thread 1 2)
10 7,000
I want to extract the pence from a currency sum by JulieS[_2_]
Hello I am working on a sheet where I need to breakdown a currency value into pounds and pence in separate columns without the pence showing the decimal point.
February 1st 17 05:30 PM
by JulieS[_2_] Go to last post
6 235
can't see highlighted colors in Excel except in Print Preview by Gator-N-Walterboro
We are having trouble at my job with Excel 2003. We can highlight cells in a worksheet but you will not be able to see the colored highlighted cell until you...
2 1,249
Run-time error '424': Object required by MrBadExcel
The code below allows me highlight one row at a time. I can scroll up and down a sheet using the arrow keys. Sometimes need to highlight two or more rows by...
January 31st 17 08:06 AM
by GS[_6_] Go to last post
5 352
Trendline formula not correct by BottleMan
Hi everybody, I use scatter charts and trendlines a lot to derive formulas from real data.. Excel then prints the formula it used on the chart. However, when...
(Multi-page thread 1 2)
January 28th 17 08:12 PM
by Wally W. Go to last post
10 572
Unable to turn off Speak Capabilities by L. Howard
I added the Speak command to my quick access tool bar, did some stuff with it looking for a solution to a query. Okay, I'm done with the Speak so I removed...
(Multi-page thread 1 2)
January 28th 17 06:57 AM
by L. Howard Go to last post
15 382
Making cells appear on screen but NOT print by Cat Slave
I need to have a macro button and a text cell that appear on the screen but not appear when printing. How do I do that?
January 25th 17 03:08 PM
by lcuerfgc Go to last post
7 1,223
Copying an entire spreadsheet by Michael Graubart
I am now using Excel 2016 on a Mac with MacOS 10.12.3 (Sierra). More than a decade ago I created a spreadsheet in AppleWorks containing many quite complex...
January 25th 17 03:04 PM
by lcuerfgc Go to last post
2 246
Duplicate macros? by Terry Pinnell[_4_]
I'm sure the answer will be embarrassingly obvious but why does my drop-down list of macros in Excel 365 contain duplicates for every one please? Perhaps some...
January 24th 17 12:32 AM
by GS[_6_] Go to last post
4 393
Why doesn't this content get fully displayed? by Terry Pinnell[_4_]
I raised this early in December and I thought I'd sort of answered it myself... But on returning to it today I still don't really understand why cell b6 get...
January 23rd 17 10:31 PM
by lcuerfgc Go to last post
3 335
script error message by [email protected]
when i open word this script error message appears continuously.How do i get rid of...
January 21st 17 11:28 PM
by GS[_6_] Go to last post
1 257
Grouping dates in pivot tables by week no. by [email protected]
Den lördag 26 juni 1999 kl. 09:00:00 UTC+2 skrev Juan Riera: > Hello, > I have been using pivot tables for long and I miss the possibility of > grouping dates...
0 262
Post New Thread

Display Options
Showing threads 41 to 60 of 146459
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 On
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 02:12 AM.

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