Search Results

I started posting Excel tips on my Linkedin page in early October 2020, and as of the 16th my "Did you know"post took the form it holds till this day. You can find my posts on Facebook, Instagram and Linkedin, all of which you can access via the links in the right hand column of this website. October 26, 2020 - Did you know that Excel can tell you the date October 23 , 2020 - Did you know that Excel can tell you the date October 22, 2020 - Did you know that Excel can tell you the date October 21, 2020 - Did you know that Excel can tell you the date October 20, 2020 - Did you know that Excel can tell you the date October 16, 2020 - Did you know .. I'm back with a little good to know "DID YOU KNOW" facts about excel. Today we're talking about Conditional Formatting. Did you know that there is a "Copy/Paste" function for conditional formatting. I love this HOW TO: First highlight the area where you just created a conditional format, click the "FORMAT" icon and then click and drag the range where you want to copy the formatting to. 210112 210113 210114 EXTENDED EXCELLENT EXCEL TIPS - Januari 2021 Jag började dela med mig Excel tips på min Linkedin sida tidigt i Oktober 2020, och i och med den 16:e så tog mina "Did you know" posts den form dom har idag. Idag kan du hitta mina tips på Linkedin, Facebook och Instagram. Alla dessa sidor kan du komma åt via menyn till höger i skärmen. J anuari 12 , 2021 - Did you know ... Welcome to a new great year of amazing #facts, #tipsand #tricks that will simply make you fall in love with #excel. Well maybe not love .. but at least learn to appreciate how great it Excel is and what an amazing tool it can be both at home and at work. Come here every weekday for the latest installment, starting tomorrow. #didyouknow #excellenthelp #goodtoknow#microsoft #tasuohoriuchi #excelartist #exceltips ps I've included one of my favorite works by renowned Excel artis Tatsuo Horiuchi. This piece, like all his work, is done using only the tools available in excel. ​ ​ ​ ​ ​ ​ J anuari 13 , 2021 - Did you know ... Did you know that this is my first #didyouknow of #2021. That is, of course, not the actual #exceltip I have for you today. To start the year I thought I would go back to basics and show some simple moves in #excel that can speed up document creation. Today I will show you how to automatically update the width of multiple columns to fit all the information in in every cell. This technique adjusts each column width to the longest thread in any cell in that column. We start with a table where everything fits, but we want to adjust the font size of our title cells and this makes it so our threads no longer fit in their cells. What we need to do then is this: 1. Select all the columns by #clickinganddraging from the first to last column. 2. Move the mouse cursor to one of the lines that separate the columns (get between the letters) 3. Once the mouse cursor changes to the icon shown in one of the pictures, #doubleclick and the width's will be adjusted. ​ ​ ​ ​ ​ J anuari 14 , 2021 - Did you know ... Hello one and all. Yesterday I left you after having showed you how to automatically widen a group of columns to accommodate the longest thread in any cell of that column. But that also resulted in many columns of varying widths. So, did you know that you can use a similar technique to adjust a group of columns to the exact same width. Much like yesterday we will select all the columns we wish to effect, place the cursor on the line between to columns, click and drag to the desired width and when you release the mouse button all your columns will be that width. This is a great way to make sure that your table/spreadsheet looks uniform and professional. ​ ​ ​ ​ ​ J anuari 15 , 2021 - Did you know ... Did you know that both of the last two days tips can also be used for row height. Well, if you didn't ... #nowyouknow. The process is basically the same, aside from the small change in that you highlight the rows you want to change. Then simply place the mouse cursor on the line between two row numbers and either #doubleclick to have #Excel automatically alter the height to adjust to your content or #clickanddrag to adjust the height of all the rows to be the same. ​ ​ ​ ​ ​ J anuari 18 , 2021 - Did you know ... So, there are moments when you want to enter the same formula in multiple cells. And there are a few different ways to do that. #CopyPaste You can enter the formula into one cell, copy the cell, select all other cells and then paste. #BUT If your formula involves a separate cell value you need to make sure that you have made it absolute. Otherwise the paste will move the chosen cell. So what do you? You select all the cells that you want the formula in first. Then you begin entering the formula into the formula bar. And this is where the magic happens. When you are done writing the formula you press Control+Enter (Command+Enter also works on #MAC). And with that simple little move, BAM ... your formula is now in every cell. ​ ​ ​ ​ ​ J anuari 19 , 2021 - Did you know ... Yesterday I made a reference to something called an #absolutereference #absolutecellreferencee). Therefore, today I will give a quick tutorial regarding what that is. Using Absolute Cell References is something that is important to know when you copy/ #clickanddragformulas into multiple cells. There are three versions for an absolute reference in #excel. $A$2 - The cell remains the same whenever the cell/formula is copied over into other cells. A$2 - The row will not change. Meaning that when formulas are copied across a row, the column will change (A-B-C ...) But when copying down a column, the row value will not change. $A2 - Here the column will not change. Basically the opposite of the previous explanation. ​ ​ ​ ​ ​ J anuari 20 , 2021 - Did you know ... Something that is very common when you are working on a large #excel document with many formulas is that you kind of forget what formulas you have in any given cell. Did you know that there is a easy function that allow you to view all your formulas without going through every cell and without risking changing the content of any cell. Simply go to the #Formulas tab and click the #showformulas button. What this button does is change the view on every cell to show the formula being used there. Then you have a great overview of your document. Don't worry about the cell dimensions changing when you press the button, they will revert when you reverse the procedure. To reverse the procedure simply click the same button again. ​ ​ ​ ​ ​ J anuari 21 , 2021 - Did you know ... Did you know that there is a lot of value in the aesthetics of a document as well. It can help both with clarity and appreciation for those interacting with it. One thing that can do a lot for your document is removing the #gridlines and the #headings (the row and column markings). Simply go to the #view tab and #uncheck the gridlines and headings box and you can see the effect that it has on your document. The process is of course reversible for when you need to adjust the document. ​ ​ ​ ​ ​ J anuari 22 , 2021 - Did you know ... Did you know that there is an easy way to freeze your top row, leftmost column or number of cells and columns. In todays example I will show you how to #freeze the top row #freezingg the leftmost column works the same way). When you have your range set up (normally with the top row being your header) all you have to do is go into the #View tab and select #freezetoprow. Now the top row will stay with you regardless of how far down you scroll. Freezing the leftmost column has the same effect. You can scroll sideways as long as you want, and the leftmost column stays in place. Come back tomorrow for the next lesson in freezing cells, rows or columns. ​ ​ ​ ​ ​ J anuari 25 , 2021 - Did you know ... Did you know that there is a way to #freeze more than just the top row or the leftmost column. #Excel actually allows you to freeze as many rows or columns as you wish, though always starting with row 1 and/or column A. All you need to do is select the cell that is one row down from the last row you want to freeze and one column to the right of the final column you want to freeze. Then go to the view tab and select #freezepanes. Once you've #clicked the icon you can see that the text changes to #unfreezepanes. In the example shown I have selected cell F2. That means that row 1 will be frozen along with columns A-E. That means that the columns with text will never be able to scroll out of screen and I will keep my title header in place at the top of the document all the time. ​ ​ ​ ​ ​ J anuari 26 , 2021 - Did you know ... Did you know that you don't actually have to freeze your top row if you have your range #formatted as a #table. It's true. #Excel, will actually place your table headers in the column title row when you scroll it out of the screen. This is one of those tips where you don't actually have to do anything, this is more of an FYI. You can see in the second picture that I have scrolled down and I still have my headers on screen and they are functional (meaning I can access the #filtering functions). ​ ​ ​ ​ ​ J anuari 27 , 2021 - Did you know ... Did you know that there are tons of great features for organizing a table within the #Excel #filter function that is imbedded in each #columnheader. 1. You can organize alphabetically, both forwards and backwards. 2. Cells that equal certain values, or does not equal that value. 3. Cells that begin with, don't begin with end with or don't end with a certain value. 4. Cells that contain something or don't contain something. It is a great way to quickly organize a lot of information to allow you to quicker get to your end goal with a spreadsheet. And of course, when you filter one column .. the entire row that goes with that cell's column with change right along with it. #excellenthelp #exceltips #didyouknow ​ ​ ​ ​ ​ J anuari 28 , 2021 - Did you know ... Did you know that you can copy any part of your #Excel document and use it in another #Microsoft document. That's right, not just Excel .. but right into a #powerpoint presentation that you are working on. Simply #highlight the cells that you want to take a snapshot of, and then on the HOME tab there is a button called copy. But it also has a down arrow that activates a drop menu that allows you to choose "Copy as Picture". Once you have it copied it is in your #clipboard and then you are free to paste it anywhere you want it. ​ ​ ​ ​ ​ J anuari 29 , 2021 - Did you know ... Did you know that there are several different #pastespecial. One very useful version is copying only #values from a range of cells that includes formulas. Sometimes you just want to lift out a snapshot of your values in a range and use it elsewhere. That is where PasteSpecial comes in super handy. All you need to do is highlight the cells that you want to #copy, copy the way you normally do .. but then. When it is time to #paste, right click and select PasteSpecial. You will be given a number of selections, in this case we are choosing values. ​ ​ ​ ​ 210115 210118 210119 210120 210121 210122 210125 210126 210127 210128 210129

We are here to help! Enter Your Name Enter Your Email Enter Your Subject Subject Phone Enter Your Address Type Your Message Here Submit Thanks for submitting! 500 Terry Francois St. San Francisco, CA 94158 Tel. 123-456-7890 Email. info@mysite.com