Tip: You can add buttons to the toolbar for changing the font and making selected text bigger or smaller.Help In my business I routinely have to change the type and color of cell borders in selected groupings of data in spreadsheets I use. Click the small arrows to the right of the font size to make the font larger or smaller. Click the Font pop-up menu, then choose a font. When a system is intelligent, its more than the sum of its parts.In the Format sidebar, click the Text tab, then click the Style button near the top of the sidebar.
![]() Sum By Font Color In Excel Update Added AWindows 10: Emoji Keyboard PanelThe new Windows 10 update added a way to insert emojis from the keyboard. See the references below for a list of ALT codes. I've only learned one code by heart: ALT+0169 is the © symbol. Hold the Alt key while you press the number sequence then lift up on the ALT key. Windows: Inserting Special Symbols Using ALT CodesSome special characters can be inserted by pressing ALT+#, where the # is entered using the number pad.When using this feature, you type (c) and then either press Enter or another character, and Excel changes it to ©. Excel: Create Shortcuts to Insert Symbols Using Auto-CorrectYou may already be familiar with how (c) automatically changes to © and (r) changes to ® in Office applications. I use this a LOT (only took a dozen or so times before I had the shortcut memorized), and you can see from my screenshot which emojis I use most recently. (Window key + Period) or ⊞ Win+.Some of the names in parentheses are the same named used for the HTML equivalent, such as ° for ° and ÷ for ÷. For example (plusmn) for ±, and (middot) for the dot you place between units in labels like N·m (Newton-meter).Files > Options > Proofing > Autocorrect OptionsThe table below lists only SOME of the thousands of symbols you might want to use. I've been doing this for years, and have found that using the abbreviated name or graphical representation in parentheses works great. A window will pop that lets you define shortcuts for special symbols.![]() I've demonstrated this in various task list and action item templates. = UNICODE( MID( text_string, ROW( INDIRECT("1:"& LEN( text_string))),1)) Symbols in Data Validation Drop-DownsUsing special symbols or dingbats within drop-down lists is a great substitute for a checkbox in Excel. It returns the numeric decimal Unicode value for the first character in a text string, like this: = UNICODE( "✔") returns 10004If you want to try something fancy, you can use the following array formula (press Ctrl+Shift+Enter after entering an array formula) to return an array of Unicode values for each of the characters in a text string. (plusmn)The UNICODE and UNICHAR functions have been available since Excel 2013 and are similar to the older CODE and CHAR functions.The UNICHAR function is perhaps the most useful, because it will return the character for a given decimal value (UTF-8 and UTF-16), like this: = UNICHAR( 10004) returns ✔The UNICODE function does the reverse. If you need a graph to show decimal values rather than just whole numbers, you can create a small picture (such as a screen capture of a Unicode character) and use it within an Excel chart to create a pictograph like the example below.Sample Pictograph in Excel using a Bar Chart and Picture FillIf you would like to see Microsoft make it easier to use Symbols as a Fill option, go to excel.uservoice.com and Vote for My Suggestion. Below is an example of a very basic in-cell pictograph.One of the problems with using symbols for pictographs is that the REPT() function cannot display a fraction of a symbol. Data Bars and Pictographs Pictographs or Dot PlotsYou can use the =REPT( text,number_times) function to repeat a character, as demonstrated in the article " Create a Dot Plot in Excel". Emoji Rating System □For a larger list of emoticons, see this page. Symbols for Ratings ★The feature comparison template demonstrates how you can use a data validation drop-down list to create a star-rating by entering ★,★★,★★★ into the Source box for the list. Copy the following characters (including the comma), and paste them into the Source field: ☐, ☑ Check Marks and Check Boxes ✓See the CRM Template for an example of how these symbols are used. Note that although there are some skinny bars (like 9612), for data bars you need to use the characters that do not include any blank space. However, Google Sheets does not have in-cell data bars yet, so using the REPT() function is one way to create something like a data bar (see the image below).The table below lists the main characters I use for this technique. You may not need to use this technique for in-cell graphics in Excel any more because of the awesome conditional formatting options. They can also be used for progress bars if the cell is scaled to 0%-100%. The example chart below is showing multiple teams' race against time.A Sprint Progress Chart Using the REPT FunctionHere is the formula for creating the in-cell sprint chart: sprint = 14 (# of days in the sprint)Time = IF( TODAY()( start_date+ sprint), sprint, TODAY()- start_date))= REPT("⚑", MIN( time, complete)) & REPT("⚐", MAX(0, time- complete)) & "⌛" & REPT("⚑", MAX(0, complete- time)) & REPT("⚐", sprint- MAX( time, complete)) & "□"Other Useful Symbols Triangles / Arrows ▬These are the symbols I like to use for up/down signals. The filled-in flags ⚑ represent the percent completed and the watch or hourglass symbol represents the current day. The "sprint" period is represented as a number of days, with a flag for each day. Download the Kanban Board Template to see it in action. This technique can be useful as a visual aid in Agile Product Development. Itools for mac youtubeSee this page for a full list. Some Sports Symbols ⚽There are symbols for each hour and half hour on the clock. Scissors ✀In combination with a custom number format of " and merged cells, the scissors can be used in forms like a remittance slip on a billing invoice to create a guide for cutting. See my Unicode Symbols page for a huge list of arrows. There are a LOT of different kinds of arrows, but I use these triangles more often than other arrows. The template I created uses the symbols within conditional formatting rules and custom number formats.
0 Comments
Leave a Reply. |
Details
AuthorAllison ArchivesCategories |