Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Add excel horizontal & vertical ruler

Why not have a horizontal & vertical ruler on a work sheet, I have been
trying to obtain an exact size of 17 cm height * 12 cm width.it is quite
impossible.
Adding the rulers as an option for the user makes it easier to perform the
sizing needed.

----------------
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


Post your answer or comment

comments powered by Disqus
Why not have a horizontal & vertical ruler on a work sheet, I have been
trying to obtain an exact size of 17 cm height * 12 cm width.it is quite
impossible.
Adding the rulers as an option for the user makes it easier to perform the
sizing needed.

----------------
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

When I try to click on rulers (it is checked but grayed out), I cannot get my
vertical ruler or horizontal scroll bar to appear. What am I doing wrong?
Thanks!

Hello, all -

I'm a newbie here, and am pleased to meet you all - this seems like a great place to get and share tips on using Excel.

I've searched this forum and other resources on the internet, and cannot seem to find the answer to a problem I have with trying to add horizontal/vertical lines to a Bubble Chart in Excel 2003:

QUESTION:
I'm looking to add horizontal and vertical lines to a Bubble Chart, parallel to the X- and Y- axes, respectively, at the points that a user specifies. Essentially, being able to break up the chart into dynamic "quadrants" that are not necessarily of the same size. (All the user would have to do is specify X=20 and Y=50 for the vertical and horizontal lines, respectively.) Is this possible, with or without the use of VBA, and, if so, how? Have any of you out there encountered a similar problem, and how did you solve it?Thank you for taking the time to read my question, and I look forward to any and all advice you may have!

Hello,
I have an area chart that shows workload in % (y-axis) over a year (x-
axis). I am trying to add a horizontal target line to that at 100% and
a vertical line that indicates today's date. I would prefer to show
all charted data on the primary axis, since the XY chart doesn't go
all the way to the top when placed on the secondary axis. I am trying
to accomplish this in Excel 2007.
I have found some great examples on the Internet to do one or the
other in a chart, but so far nothing that indicates I can do both. Is
it possible to add both lines in?

Apologies for being so vague on the actual problems I am having, but
in all my attempts so far, the chart has shown some very eratic
behavior and crazy results, for example, all charted data (area and
line chart) disappears, the data label for the vertical line
disappears if I move the line from the secondary axis to the primary
axis, oh, and my favorite one, Excel crashes alltogether.

All help and suggestions would be greatly appreciated.

TIA.
Antje

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

How does one get both horizontal and vertical frozen panes in Excell
spreadsheets? Tried split as described by Microsoft and it does not operate
as desired. Am looking to have the first row be 'frozen' at the top when
scrolling down and the first 3 columns 'frozen' at the left when scrolling
across.

Hello everyone,i'm new to these forums, this is my first post
anyway this year on college i've started to use Excel more actively and i have a couple of questions for those who have more expirience (and the will to answer )

i have a question about XY scatter charts
i've drawn chart like 31880413.jpg
it dosen't matter what those lines are

my question would be is there anyway to automatically add horizontal and vertical XY lines preferably dashed one's
you know, i choose some coordinate T(x,y) and i get vertical and horizontal axis lines
something like copyyt.jpg
that chart was edited in paint it's easy to do it if i have like 2-3 lines, but we have much more complex charts and that's where things get complicated
and if i edit it in some other program i loose Excel editing options
i use excel 2007, 2010

if there is a way can someone explain it please
thank you

hi all,

is there any tricks to vlookup data ID below?
( i used to vlookup if they in same horizontal line)

there is several code unmatched (PC2001-PC2005), but this is horizontal and vertical data to lookup to

(i need to lookup / match yellow code with orange code)

thanks all for helping me

Sheet1

*BCDEFGH2*******3**acerpackardtoshibavaiodell4**PC2001PC2002PC2003PC204PC20055*******6*******7*******8PC2001acer*****9PC2002packard*****10PC2003toshiba*****11PC2004vaio*****12PC2005dell*****13*******

Excel tables to the web >> Excel Jeanie HTML 4

Hi Folks, I am pretty much new here, been cracking my head for the past few days trying to figure out a formula to do this hit on Google and found this board. What I would like to do is to move data from Horizontal to Vertical based on Column A. Whereby identical data in column A will be merge. It does not have to be on the same sheet, I am not to sure if this is possible with formula. Kindly refer to the screencap below which pretty much explains everything.

Would really appreciate if someone could help me, TQ

******** ******************** ************************************************************************>Microsoft Excel - Test.xls___Running: xl2002 XP : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutF15=
ABCDEF1Job*NumberChargeAmount**From*This2KLX01THC100***3KLX02Others80***4KLX02THC10***5KLX02GST20***6KLX03THC20***7KLX03Others10***8KLX04GST60***9******10******11Job*NumberTHCGSTOthers*To*This12KLX01100****13KLX02102080**14KLX0320*10**15KLX04*60***Sheet1*
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

I want to create a form to be filled in. Is there an Excel 2007
method to create horizontal and vertical lines, making boxes? Column
1 is to print master information.

David Ames

Kindly please help to convert from Horizontal To Vertical Format. Its about 1000 rows The sample data are,

Item Desc Item2 Desc2 Qty
1 A 1A 1AA 1
1 A 1B 1BB 2
1 A 1C 1CC 3
2 B 2A 2AB 1
2 B 2B 2BB 7
3 C 3C 3CC 10

Results Required will be,

Item Desc Item2 Desc2 Qty Item2 Desc2 Qty Item2 Desc2 Qty
1 A 1A 1AA 1 1B 1BB 2 1C 1CC 3
2 B 2A 2AB 1 2B 2BB 7
3 C 3C 3CC 10

Thank you.

I frequently annotate Office documents using the Drawing tools available within all those applications.

My problem occurs when I resize lines I've drawn. I cannot get them to remain perfectly horizontal or vertical. I generally rely on the use of the Shift key while dragging to ensure that the line remains horizontal or vertical as I resize it.

But this doesn't work in Excel 2007 or PowerPoint 2007 (not sure of Word 2007),

The application insists on shifting the line-end I'm dragging to a grid that's off plumb by one increment.

I've checked to ensure that any "snap-to" options are disabled, though in the 2003 versions of these apps, the Shift key would override any snap options.

This is driving me crazy!

Any assistance would be greatly appreciated!

Thanks, strider

How do you freeze horizontally and vertically at the same time?

Dear All

Need your help urgent. Am looking for a VBA or formula to do sorting from horizontal to vertical. Attached is a sample

Beside this, the process should ignore the yellow highlighted cell. There were thousand of Product category and branch.

Thanks in advance

Hi,

What is the best way to have both horizontal and vertical axis as value axis?

Thanks

I am writing a function that asks the user to input a range.

At the moment I have it set up so that the range has to be in a row. The
formula then goes off and does something with the values one by one along the
array until it reaches the last one.

Is there a code I could put in so that it would not matter whether the user
made the array horizontal or vertical?

Thanks

I have a user trying to create a contour chart or any chart for that matter
using values from different spreadsheets going horizontally and vertically.
These are well depths so, when one value ends vertically on one of the
spreadsheets the next spreadsheet begins horizontally. Is there a way to
effectively and attractively create this kind of spreadsheet? Please let me
know.

Hi All,

I have data in the form of headers in Row 3, but need to compare this to date found in Column C(rows 970-975) . Thus, I would like to be able to freeze panes twice, so that I could have the data in Row C as a header and that in Column C (between rows 970-975). Is this possible? It seems as if I can only freeze the horizontal and vertical planes if they are located TOGETHER.

Thanks!

http://www.excelforum.com/images/smilies/frown.gif

Dear All

Need your help urgent. Am looking for a VBA or formula to do sorting from horizontal to vertical. Attached is a sample

Beside this, the process should ignore the yellow highlighted cell. There were thousand of Product category and branch.

Thanks in advance

hi
i want to add excel sheet on my vb form.So i used oledb control . But when i
clicked on excel sheet it adde a new menu on the top of the form that is not
my requirement.i also want to control all the functionality of excel sheet by
using programming.

Is it possible to add only excel sheet on my form with all functionality
but without any menu along with.

I want to add excel templates that I have downloaded - from Microsoft - to
the spreedsheet solutions box. When I create a new spreedsheet I want these
to show up when I select 'On my computer' when I look for a template. I have
addded then to the same directory that Microsoft uses for the default
templates but they don't show up when I am in Excel.
Thanks

Excel, like Word should have vertical and horizontal rulers. Cell width and
height should also be able to be measured in inches. I don't understand why
this hasn't been already implemented into Excel.

----------------
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

Excel, like Word should have vertical and horizontal rulers. Cell width and
height should also be able to be measured in inches. I don't understand why
this hasn't been already implemented into Excel.

----------------
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

Hi I have a chart I wanted to plot data from 1 - 10 on both the x and y axis. This has worked but due to the size of the labels excel has made the range larger. I can hide all the intersecting lines most easily by making all the major grid-lines 100% transparent, but I needed to mark the half way point chopping my data plots into quarters.

I need to add a horizontal line going all the way across the chart at 5 and a vertical line going all the way up the chart from 5.

Do I really have to create a whole new series as an average and plot it to achieve this or can I just get excel to add them based on an intersection?


No luck finding an answer? You could always try Google.