Help Community Login:
Re: How do I freeze rows and columns at the same time in ...

Ah, been there done that Autumn, but it's easy peasy!

First of all instead of trying to freeze each one individually you actually do it simultaneously as follows:

Assuming that you want to freeze the "EMPLOYEE" column and the first 3 rows.

You will go to the cell that is directly to the right of the column you want to freeze and in this case the 4th row down (you said you wanted to freeze the top 3 rows) you always go to the row directly under the rows you want to freeze.

Then you go to "View" on the top menu, then click "Freeze Panes" to get the drop down box and hit Freeze Panes

You will now see 2 solid lines which indicates that anything to the left and above those lines are frozen.

Hope this helps and happy scrolling Big Grin

"...There is nothing that isn't great about you" ~~~~ A Friend

Reply

The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <embed> <object> <strike> <caption> <thead> <th> <param> <style> <BGSOUND> <color> <center> <font-size> <script>
  • You may quote other posts using [quote] tags.
  • Filtered words will be replaced with the filtered version of the word.
  • Textual smileys will be replaced with graphical ones.
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <csharp>, <css>, <html4strict>, <javascript>, <php>, <vb>, <vbnet>, <xml>. Beside the tag style "<foo>" it is also possible to use "[foo]".
  • Lines and paragraphs break automatically.
  • You can use BBCode tags in the text.

More information about formatting options



NOT LOGGED IN

You are NOT logged in

NOTE: You are commenting as an anonymous guest. You will NOT immediately see your comment, but it's there. Please do not try to re-send the same comment. If you'd like to see it immediately, please login or create an account (no worries, it's free).


facebook codes exploits tips tricks Phrozen Crew
All contents ©Copyright GeekDrop 2009-2012
TOS | Privacy Policy