Free Microsoft Excel 2013 Quick Reference

Ruler in Excel

It would be great if there was a ruler option in Excel so that columns & rows
could be sized more easily than entering an amount in a pop-up box. The
ruler, like in Photoshop, should be able to be adjused to display in inches,
points, and any other size format that may be useful. Having to convert
points to inches is a bother and, after all, the reason for Excel is to make
it all a lot easier.

Thanks!

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming


Hi Guys

Can you please help me with a code which can allow me to hide Gridlines and Rulers in Excel 2007.

Many thanks,
Heaven

I am wondering if there will be room for a ruler in the excel program. I drew
a roof in 5 min with the boarder feature but there's no where that I could
find that you can caluate the measurments
--
Viv

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

I am wondering if there will be room for a ruler in the excel program. I drew
a roof in 5 min with the boarder feature but there's no where that I could
find that you can caluate the measurments
--
Viv

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...heet.functions

I wish to plot x-y scatter graphs to scale e.g. on a landscape A4 size page.
I need the y (vertical) axis to be exactly 99mm long and the x (horizontal)
axis to be exactly 240mm long.

As I cannot find rulers in Excel I insert the graph in Word and turn on the
rulers. I then stretch the “chart area” until the axes are the correct length.

This usually works. However, sometimes it does not work e.g. the y axis
might be around 20mm too long for no apparent reason but the x axis will be
correct. I also notice that if a text box overlaps an axis the length of the
axis changes.

Is there another way of achieving graphs to scale? Can the size of the “plot
area” be set precisely?

Can you also let me know if there is some sort of “show all characters”
command in Excel, which could be used to identify empty text boxes, which are
invisible?

This is a quote from Office Excel Help, "Unlike Microsoft Word, Excel does
not provide a horizontal or vertical ruler, and there is no quick way to
measure the width or height of a worksheet in inches." Well, why not? (Just
the fact that it is written so clearly in Excel Help means I am not the only
one to look for it.

Make rulers available in ALL office apps, not just Word. Getting columns
and rows to fit correctly on a page is important. It shouldn't be a chore.
Just make the rulers available so we can see what we are doing without having
to go into and out of page setup and the format funtions. (Clarisworks did a
decade ago.) Office 2003 takes up half a CD-ROM and is chock full of
features I will never use. But Clarisworks V3 is a 10 MB install and still
has more usefull features for the avarage person. The only reason I use
Office 2003 Professional is for compatibility with others. Please stop
bloating it and make it more functional for basic users like me.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

It would be nice if there was a guidebar available in Excel that would allow
you to move it across or up and down so that you could follow columns or rows
more easily. It should work similar to using a ruler on a piece of paper to
help when reading a paper with a large amount of text.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...heet.functions

I have some embedded PDF files in Excel file. I want to save them in a separate folder as seperate files, by pressing a button in toolbar.
How to do that using VBA?

Thanks

Hi,

I am trying to figure out a way to work with the date functions in Excel 2007. I have noticed when you enter a wrong date in a cell such as April 34, 2012 excel considers that cell as an error. I am trying to figure out a formula (not sure if an IF Statement will do it) to refer to the date cell and tell me the Day portion of the cell must be adjusted.
The same issue with Month. If I enter a month that is greater than 12 for example 17th month, 10th day and 2012 year, the formula will display adjust month. I know I could use the IFERROR function but I have 2 cells to help me with the date errors, and if I use IFERRORS in both cells, both cells display Adjust Day and Adjust Month not clearly identifying which part of the date enterd is in error.

Thank you.

Hi, I'm playing this game and would like to calculate which buildings are worth my time

Following things are from a game and I want to calculate what's the best things to use

Buildings make cash for me

Building 1 makes 80 coins every 2 min
Building 2 makes 120 coins every 5 min
Building 3 makes 160 coins every 8 min
Building 4 makes 200 coins every 12 min

Question is, how can I make excel calculate it on an hour and 24 hourly base?

How would I put these calculations into Excel. I figured it out with other stuff, but they were hourly bases
Building 1 makes 600 coins every 4 hours, that's 3600 in 24 hours. In Excel that would be =(D3/B3)*24
D3 being the 600 B3 being the 4 hours

I hope this is allowed to be asked on this forum, as it's not the normal kind of Excel question I suppose.

Thanks for any help!

Hi all,

Apparently one 'save as picture' option should be available in shortcut menus when I rightclick any image or picture in excel 2007, but I just couldn't find it.

I was trying to save a smartart as jpeg and I came across this article http://office.microsoft.com/en-us/ex...010337415.aspx I tried following it, but no luck so far, that option is just not there.

Any idea on why my excel 2007 is missing that option?

Thanks.

Is it possible that if i press tab in excel my active cell offsets by a row and two negative columns.

Any Help will be appreciated.

Hello everyone,

Looking at Mr. Ron's VBA script examples (http://www.rondebruin.nl), I modified one accordingly for one of my office work.
I am a recruiter for a company and maintain a database of all candidates in excel. Every time a candidate gets accepted or rejected, I have to send him an e-mail of acceptance or rejection. To avoid the repetitive task of manually logging in and typing the text, I thought of making my life easy by working on excel macros.

I would be very thankful if someone may have a look at the spreadsheet I created. I would like you to modify the code a bit if you can spare some time for me in the following manner.

1)I created a list box in column "I" for status. If you select Accept, it sends an acceptance e-mail which is shown in column J along with a time-stamp in column K.
Same thing happens if you select Reject in Status (I column).

The first option in the drop down menu is a BLANK value, incase I do not want to send any emails to particular candidates.

Now what I would is if I add more rows for candidates and want to send an email to only those, how can that be done?
In the current code, it is resending all candidates again.

Is it possible to add a dialogue box which would ask the user :- Would you like to resend "acceptance" or "rejection" email [depending on what you selected in column J] to [persons name] from column A?"

If selected "yes" then resend the email, if selected "no" then do not do anything and proceed to the next row. It would be great to have an additional button of "NO TO ALL" along with "Yes: or "No".

Suppose I had earlier sent emails to 30 candidates and added only a few candidates at the end of the sheet. Now if I only want to send email to those new ones, if we run the code, I do not want to click 30 times on "No" button when I get a pop up which says " Would you like to resend " acceptance" or rejection email to "XYZ" candidate"?

Rather there should be a button of "No to all" by which it sends email only to the newly added candidates and doesnt ask me to resend email to the above already sent candidates.

I would be very thankful if you can help me.

Best regards,

Zain

Hello Sir,

Kindly help me in excel

I have one doubt that is

I put the text in the columns of A B C D and now I would like to lock the C Column if something enter in B Column and it will open Automatically if nothing in B Column
how can it will work,

2. now I am maintain the stock book in excel and I want the reports individual brand in next sheet

Ex A - OB, B - Receive, C - Total, D - Sales, E - Balance and in F column I mention the Brand of the Item

now I want the stock report in each sheet with the brand items

3. I Share my excel Work Book, it's working but it's open solely in other system why it's happen and how can I manage multiuser password for each system to the same excel Work Book with different access

Kindly help me about the above problems

Hence I oblige

Thanking You

How to use this code in excel 2000?

See..


	VB:
	
 FileDialog[/FONT][/COLOR] 
[COLOR=#333333][FONT=Lucida Grande]Dim arquivo As String[/FONT][/COLOR] 
[COLOR=#333333][FONT=Lucida Grande]Set fd = Application.FileDialog(msoFileDialogFolderPicker)[/FONT][/COLOR] 
[COLOR=#333333][FONT=Lucida Grande]If fd.Show = -1 Then[/FONT][/COLOR] 
[COLOR=#333333][FONT=Lucida Grande]arquivo = fd.SelectedItems(1)[/FONT][/COLOR] 
[COLOR=#333333][FONT=Lucida Grande]MsgBox "A pasta selecionada é " & arquivo[/FONT][/COLOR] 
[COLOR=#333333][FONT=Lucida Grande]Else: arquivo = ""[/FONT][/COLOR] 
[COLOR=#333333][FONT=Lucida Grande]End[/FONT][/COLOR] 
[COLOR=#333333][FONT=Lucida Grande]End If[/FONT][/COLOR] 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


I have a worksheet in Excel 2010 and I want to set a reminder to look at a particular row of information on a date in the future, can be by message/pop-up box or just the row changing colour. I do not have any dates set within the core information, and want to avoid putting in an additional column for a date if possible.

Can I use Conditional Formatting to say something like - when today is x change the format of the cell (or row) to...?

I don't think I can put an actual date into the formula line, or can I?

I've been doing some sql in excel; so far so good. Sometimes I will mistakenly run a query that takes a long time; requiring a restart of excel to be reasonable. I'd like to abort queries that are out of control. Here is my code, with the things I've tried that didn't work commented out. Can queries be stopped or limited beforehand? Also posted:

http://www.mrexcel.com/forum/showthread.php?t=637301


	VB:
	
 ADODB.Connection 
 'ISeriesDataCN.CommandTimeout = 1 'did nothing: I assume these are seconds
 'ISeriesDataCN.ConnectionTimeout = 1 'did nothing
ISeriesDataCN.Open "Provider=IBMDA400;Data Source=censored; Force Translate=0", "", "" 
Set ISeriesDataCM = New ADODB.Command 
ISeriesDataCM.ActiveConnection = ISeriesDataCN 
 'build sql statement
sqlsel = "Select *" 
 'sqlsel = "Select top 100 *" 'token 100 not valid
sqlfrm = " From PRDDTA73.F4101" 
sqlwhr = " Where IMITM

Hello, I’ve lately been struggling to speed-up a process of compressing data in cells by utilizing the Range.SpecialCells method. Everything works fine in Excel 2003 and 2007 with execution time of 15 to 20 seconds. Very recently I upgraded to Excel 2010 (32 bit) and over there the execution takes 4 minutes and in some cases even much more. I have a couple of questions in that regard:

Would an upgrade to Excel 2010 (64 bit) dramatically speed up the process at least to the speed I experienced with Excel 2003 / 2007? From my understanding, an upgrade should be considered when dealing with 100,000’s of rows. The range my code covers is only B20:MC3020.Is there a parallel method to compress the data in Excel 2010 that I'm unaware of? I tried applying the data compression through an array which I found in MrExcel forum. The speed remains the same in any of the Excel versions.
This is the code I’m trying to use:

	VB:
	
 Data_Compress_Test() 
     
    Application.ScreenUpdating = False 
    Application.Calculation = xlCalculationManual 
     
    With Sheets("5 Day") 
        .Range("10:10,19:19").ClearContents 
        .Range("B20:MC3020").SpecialCells(xlCellTypeConstants, 2).ClearContents 
        .Range("B20:MC3020").SpecialCells(xlCellTypeBlanks).Delete Shift:=xlToLeft 
         'Compressing the data
    End With 
     
    Application.Calculation = xlCalculationAutomatic 
    Application.ScreenUpdating = True 
     
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
SpecialCells(xlCellTypeConstants, 2).ClearContents is needed because the cells in the range are results of formulas which are being pasted special (values only) from another sheet. The result can either be 1 or "" (double quote signs). There’s no problem with the execution of that line however.

This is the line that causes the HUGE delay in 2010:

	VB:
	
.Range("B20:MC3020").SpecialCells(xlCellTypeBlanks).Delete Shift:=xlToLeft 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
All I want to achieve is to delete blank cells in between the 1’s in each column and compress the 1’s to the left as a consequence. I attached a file that contains the code and some sample data ready for a test run. I would really appreciate if somebody can test how fast it runs in Excel 2010 (64 Bit) and shed light on a possible solution to the low speed performance if an upgrade to 64 Bit won't help.

Hello,
I have a Word document that I need to search for a specific word, copy the entire sentence, and then paste into the next available row in excel. Is there a way to do this using Macros? I don't have much experience setting up the Macros, beyond, "record".

Any help would be appreciated.

Thanks.

Hi,

I'm facing some problem in splitting string in excel.
Suppose in a cell I have a value Column:Period. I want to split this string and store Column and Period differently and use them in different ways.
How can I do this?

Thanks
Agniva Chatterjee

Page breaks set in Excel disappears when posted into Word doc. No offense intended. I realize I'm straddling the fence between an Excel and Word question. JC

Hello, I'm a bit new to excel and would like to present the following equation in excel to find x and y: 0 + 1x = 100 + 2y, 100 + 2x = 200 +5y. Now I already know the answer to x and y (x = 300 and y = 100), I just wan't a quicker way of finding x and y in the same format of the equation above for example A + Bx = C + Dy, 2A + 2Bx = 2C + 2Dy. Thanks

Hi,

I have the following problem in my VBA application.

VBA :

	VB:
	
 
Dim dtrefdate As Date 
dtrefdate = "1/1/2011" 
strget = ActiveWorkbook.Sheets("Sheet 1").Range("A1") 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Excel:
Sheet1.A1 contains the following
DateDiff("D", dtrefdate , Now) & " is the date"

What I expect from the code is that strget holds a value like "5 is the date" but it ends up holding "DateDiff("D", dtrefdate , Now) & " is the date"

If I try the following , it works.

VBA

	VB:
	
 
Dim dtrefdate As Date 
dtrefdate = "1/1/2011" 
strget = DateDiff("D", dtrefdate , Now) & " is the date" 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

I need to keep in excel as it can be configurable. Appreciate any thoughts on how to acheive this!
Thanks!

Hi,

I am writing a Point of Sale system in Excel using VBA. (It is long story as to why I am doing this and I know it is probably crazy using Excel and VBA as the basis for a point of sale system but it seems to be working!!)

I currently have an Excel worksheet which is used to hold the items in the sale:

Column A = Item Code
Column B = Quantity
Column C = Item Price
Column D = Tax Code

What happens is, when the user enters an item code in column A using VBA I look up the products details which are stored on a separate worksheet and copy across the item's price and tax code. When the user clicks a 'take payment' button on the worksheet I use a userform to inform them of sale total and for them to enter different payment methods / amounts. When the user has taken payment then a receipt is printed out and the sale's data is stored in another worksheet. The person who I am writing this system for has asked me if I could incorporate multibuy deals into the sytem, specifically:

1) Buy X DIFFERENT products from a selection of products and get them @ a set price - this would enable you handle bundle deals eg. bundle 3 items together for a set price
2) Buy X (SAME OR DIFFERENT) products from a selection of products and get them @ a set price - this would enable you do handle 'Buy get one free' kind of deals, '3 for 2' kind of deals and '2 CDs for Ł15' kind of deals

Working out which multibuy deals apply to the list of items the purchaser is buying has made things more difficult than just adding up item prices for the sale. Obviously I need to add a 'tag' to each product's details identifying what kind of multibuy deal (if any) it is linked to. However at this point I am struggling to know how to program these multibuy deals using Excel Worksheets and VBA. For me what seems to makes it more difficult is that for each product line in the sale the quantity of each item (Column B above) could be greater than 1.

I am not looking for anyone to write the code for me, but if anyone can help by suggesting an outline for a general algorithm to work out which multibuy deals to apply to the sale I would be very grateful!!

If I am posting this query in the wrong place I apologise and could you direct me to the best place to post it.

ALSO posted on: http://www.mrexcel.com/forum/showthr...03#post2741203

Thanks

Martin

I would like to create an email hyperlink in an excel cell that will link to an email distribution list/contact group instead of an individual email address. I have tried inserting each email individually, but it makes my 'TO' line look very messy, and some of the recipients I would like to cc versus send to. Is there a way to hyperlink an email distribution list/contact group in excel? I am using Microsoft Office Suite 2010 on a pc.