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
What determines location of VBA code from recorded macro? by Terry Pinnell[_4_]
I recorded a macro (as a basis for editing, maybe with help here). But how are you supposed to know where to find the VBA code please? I assumed it would be...
Yesterday 04:19 AM
by GS[_6_] Go to last post
1 45
Delimiter(?) by GARYWC
How can I separate data preceded by '<<' (without the quotes) into different columns? Here's sample of my text file: << NOT a relative>> << Anyone...
February 25th 17 09:52 PM
by GARYWC Go to last post
0 24
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 10:56 AM
by Terry Pinnell[_4_] Go to last post
1 79
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 08:02 AM
by Longberry Go to last post
1 196
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,005
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 11,796
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 10:23 AM
by GS[_6_] Go to last post
7 251
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,321
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 07:59 PM
by Claus Busch Go to last post
3 208
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 01:23 AM
by zvkmpw Go to last post
1 282
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,644
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 06:30 PM
by JulieS[_2_] Go to last post
6 140
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,167
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 09:06 AM
by GS[_6_] Go to last post
5 269
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 09:12 PM
by Wally W. Go to last post
10 385
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 07:57 AM
by L. Howard Go to last post
15 248
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 04:08 PM
by lcuerfgc Go to last post
7 1,116
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 04:04 PM
by lcuerfgc Go to last post
2 167
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 01:32 AM
by GS[_6_] Go to last post
4 281
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 11:31 PM
by lcuerfgc Go to last post
3 232
Post New Thread


Display Options
Showing threads 1 to 20 of 146438
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 12:33 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.