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
Protect an Excel WorkSheet from being deleted by Trader_in_Paradise
I have a blank WorkSheet called "Scratch" in an Excel workbook with lots of VB code. I want the user to be able to do anything with the blank WorkSheet...
6 2,161
Sorting protected worksheet & workbook by Sue
Operating excel 2003 I have an excel workbook which is protected but sort has been checked in the protection box. This worksheet sorts column F into date of...
8 703
How to protect macro cointained Worksheets and workbooks by using by Harshad[_2_]
I have prepared 10-12 macros, which i want to protect by password. I also want to protect worksheets and workbook that cointain above protected macro. Thank...
7 358
How secure is Excel 2007 worksheet protection? by Greg Lovern
I have a friend who wants to protect the formulas in his workbook from being seen. Is the worksheet protection in Excel 2007 any more secure than in earlier...
3 661
Using text values in Pivot Tables by Eric
I am creating a simple pivot table with one field of values, numbers to be summed, and a second field, occasional two letter alpha codes which are...
(Multi-page thread 1 2)
Yesterday 10:56 AM
by TheSunriseBay Go to last post
12 2,840
Day Trading Spreadsheet by Jack
I have created a spreadsheet that captures all the trades that I make and does a few calculations for profit/loss and stop loss calculations. While a trade is...
Yesterday 10:54 AM
by TheSunriseBay Go to last post
2 37
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.
January 9th 17 08:51 PM
by zvkmpw Go to last post
7 16,425
Excel insits that I use absolute cell references by Espen
Sometimes if you are referring to a cell in another sheet (in the same workbook) Excel decides for no apparent reason that all your references should be...
6 589
How to send messages from computer by Hbkkiyt
Want to send text from computer ? Or want to group texting people from computer ?Coolmuster How to Print Text Messages is the smart Android messages backup...
January 5th 17 06:35 AM
by Lansjter Go to last post
3 934
SUMIF function and cell /sheet reference by apache007
Dear Excel Experts, I have the following tables on my sheet 11 Mar 09 SUP1 $30 1 Apr 09 SUP1 $50 2 Apr 09 SUP3 $10 4...
4 430
Simple Charting Problem, Please by Bob[_19_]
Hello, Using Excel from, I think, 2007, and Windows 10. Haven't used in a while, and I am probably forgetting things, but this is really confusing me. If...
(Multi-page thread 1 2)
December 27th 16 04:56 PM
by kqxsmn Go to last post
11 286
Remove Numbers from Alphanumeric String by Dave
Hi, I have a value in Cell A of ABC123. I want Cell B1 to contain the 123 from this cell. Can anyone tell me the formula to enter in B1. I'm sure I've seen...
(Multi-page thread 1 2 3)
December 25th 16 03:33 AM
by Thế45363 Go to last post
27 1,842
Trapped in a cell! by [email protected]
On Wednesday, October 23, 2002 at 2:01:10 AM UTC-4, Hudan wrote: > After creating a data table, I double clicked into a cell > and deleted its contents. When...
December 15th 16 02:13 AM
by bdshl009 Go to last post
3 347
Angry
Scroll bar disappears by Michael Graubart
I have upgraded to MS Office 2016 on my Mac with OS 10.12.2 (Sierra). In the computer's System Preferences/General I have scroll bars selected to be visible...
December 15th 16 01:54 AM
by bdshl009 Go to last post
1 194
Mail merge from excel to word SUCKS by danny1234
Hello, I have a excel sheet and I just want to print labels on a a4 page with 3 columns and 5 rows. This seems to be impossible with WORD 2007. I use mail...
December 13th 16 08:26 AM
by Sandytran144 Go to last post
6 1,496
merge two excel files like in word mail merge by azmerritt
can you merge a list of names that is in an excel spreadsheet (client listing) into a "document" that is also done in excel? I'm trying to do "mail merge"...
December 11th 16 10:23 PM
by TabooCheddar Go to last post
1 1,822
Choose function not working by Dave1972
Excel Masters, I can't get my choose formula to work =A2*(CHOOSE(INDEX(MATCH(B2,period,0),1),52,26,12,2)) Essentially doing up a home budgeting sheet that i...
December 11th 16 12:15 PM
by Claus Busch Go to last post
3 219
Coverting Lotus 123 files to use with excel by [email protected]
On Sunday, June 20, 2004 at 2:18:07 AM UTC-7, Harlan Grove wrote: > "Muffin1947" > wrote... > >I have several hundred...
0 195
DROP DOWN MENUS with formulas by curiousgeorge
I am trying to create an easy budget. I have a drop down menu with pay periods or bill payments as daily, weekly, bi-weekly, monthly etc. These are all in a...
December 10th 16 10:19 AM
by Dave1972 Go to last post
6 665
Pivot ungrouping on refresh? by Me!
Hi, I have a pivot table where the ROW field is a date that is grouped by month & year. However, when I change the data source to include additional rows...
6 2,203
Post New Thread


Display Options
Showing threads 1 to 20 of 146422
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 11:54 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.