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
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 299
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,233
how to unhide multiple rows in one go? by Satnam Randhawa
I have a worksheet with close to 100 rows out which 15-20 are hidden. How do I unhide all the rows in one work sheet in one go without having to drag them...
(Multi-page thread 1 2 3 ... Last Page)
40 12,495
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 416
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 17,941
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 283
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 347
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 6,791
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 183
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,211
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 319
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 482
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 305
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,161
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 204
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 342
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 277
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 210
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 217
1 Attachment(s) Sorting dates in Pivto table by Excel Dumbo
Dear friends, Please find attached sheet I would need to create two pivot table with the below column headings Pivot table 1 Column heading-...
January 17th 17 12:39 PM
by Claus Busch Go to last post
1 335
Post New Thread


Display Options
Showing threads 21 to 40 of 146447
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 07:21 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.