You want to filter by all students with an A.ġ. ![]() Let’s say I would like to use the custom Filter buttons we play with in Excel Essentials. There are actually quite a few ways that merged cells can be problematic. Perhaps someone did this in an attempt to make their spreadsheet look less cluttered? Let’s see why this might have been a bad idea. If you select any of these, notice in your A lignment group that Merge and Center is selected. The first row of data contains 3 sets of merged cells: A1 with B1 C1 with D1 and E1 with F1. This is a fictional list of students and grades, with some merged cells at the top. If you would like to follow along with my demonstration below, here is an Exercise file: MergedCells That being said… not only is the beauty of a spreadsheet less important than its functionality, which is definitely adversely affected by merged cells… but there is actually a way to alter the appearance identically to merging cells without all of the many disadvantages that come with merged cells. ![]() People usually merge cells in an attempt to make a spreadsheet look nicer. ![]() Friends don’t let friends merge cells! This is something you hear often among Excel enthusiasts.
0 Comments
Leave a Reply. |