I forwarded the file to myself also using excel 2010 and it. We can see the down arrows but when you click it nothing happens.
My boss is trying to fill out an excel spreadsheet Using Excel 2010. Alternatively, to create a custom border style, use the Line Style, Line Weight, and Pen Color drop-downs to select the border’s style, thickness, and color. Place the cell in the F column as shown below in the screenshot to get the drop-down list menu. To apply or remove a preset custom border style, click the Border Styles drop-down button in the Borders button group and then click the style to apply from the drop-down menu that appears. Choose the List option from the drop-down list. Make changes as desired by navigating the Format Comment window with the navigation tabs at the top. Posted by tcur89 on Feb 6th, 2015 at 1:56 PM. You will get the dialogue box which will show validation criteria.then go into Excel, click on the relevant cell and: Go to the DATA tab. So you can copy a tick (highlight the one below and click CTRL and C). Firstly you need to find a suitable tick or cross.
It is surprisingly easy to add a tick into data validation. While in the edit mode, hover the mouse over the edge of the comment until you see the cursor change to a four way cross with arrows at the ends. Add a tick/ cross into your Excel Data Validation.Simply uncheck a check box if you dont want to control this type of formatting. Enter a name and click the Format button to define the Number Format, Alignment, Font, Border, Fill and Protection of your cell style. In addition to changing the shape, you can also change a variety of other style options. Select the range of cells by clicking on one and dragging your cursor over them. On the Home tab, in the Styles group, click the bottom right down arrow. From the drop down menu select your new shape for the comment box.In the Illustrations section, press the small Shapes icon.Hover the mouse over the edge of the comment until you see the cursor change to a four way cross with arrows at the ends.The default comment box in Excel is pretty plain, but you can change the shape, colours, fonts and borders among others things to make them stand out.Įnter the comment format editing mode by clicking on the comment and you will see small squares around the comment.