If you use Microsoft Excel, you'll recognize that it is a powerful application, capable of acting as a full-featured spreadsheet and data analysis tool.
While Excel is fully capable of some powerful data manipulation tasks, sometimes you need to do something simple like merge and unmerge cells. That essentially means placing the value of one into multiple cells or two cells into a single cell. That's exactly what we're going to cover in this how-to.
A desktop or laptop with Microsoft Excel
The easiest way to merge a single cell into multiple cells is using the Merge and Center command from the main menu. This command takes the value in the left-most cell in left-to-right languages or the right-most cell in right-to-left languages and places it into however many cells are selected. It's particularly useful when you want a column header to cover multiple columns, such as in the sample spreadsheet where we would like the "Q1 Sales" title to refer to all of the first quarter months.
(This data might later be used to create a graph in Excel.)
Step 1: Select the cells you want to merge into and click on the Merge and Center command.
Step 2: If you simply click on the Merge and Center button, then the "Q1 Sales" will be spread across the three cells and centered. Note that any data in the cells to the right will be overwritten.
Step 3: You can also select Merge Across and the cells will be merged but the content will be moved to the left. The Merge Cells function will do the same in most cases.
It's easy enough to unmerge cells that you've merged using the Merge Cells command.
Simply select the cells you wish to unmerge, and select Unmerge Cells from the drop-down menu.
Sometimes we want to take two columns and merge them into one, keeping the information from both columns. In our sample spreadsheet, we'd like to take the first name and last name and combine them into a cell containing the full name.
This is easily done by using the Concatenate function. We create the formula in the cell where we want the full name to populate. The formula is in the format "=CONCATENATE(A2," ",B2), where A2 refers to the left-most cell in the second row, B2 refers to the right-most cell in the second row, and the middle section indicates that we want the data separated by a space. Of course, the cell references will change as you move down your table. We could use any symbol we like here. Note that any data in the column where the data is to be merged will be overwritten.
Using these steps you can easily merge, unmerge, and generally manipulate the layout of your spreadsheet. It has possibilities beyond a simple table, as you'll discover with regular use.
Recording important data that you don't want changing? Learn how to lock cells in Microsoft Excel and protect your data.
The absolutely absurd idea of putting a touchscreen display on a mouse isn't exactly new. Turtle Beach already did it with its Command Series MC7, which features a 2.25-inch control screen. But apparently, even that wasn't ridiculous enough for Arctic Fox Technologies. Its new Super Mouse looks like someone took the chunky old Atari ST mouse, slapped a touchscreen and scroll wheel on it, and called it an upgrade.
The result is a rather unusual-looking mouse that is now on Kickstarter, starting at $199. And as ridiculous as it looks, some of its features are genuinely intriguing.
Apple is less than a day away from launching its highly anticipated OLED MacBook Pro with a touch-sensitive screen. But it appears that the upgrade is going to cost a pretty penny. According to a report by Bloomberg, Apple is reportedly eyeing a starting price of $2,899 for the 14-inch MacBook Pro, while the 16-inch version could start at $3,399 in the US.
"At $2,899, the 14-inch model would mark the highest starting price for a new MacBook Pro model, surpassing the $2,799 Apple charged for a 17-inch version introduced in 2006," says the report. The report claims that Apple is targeting a minimum price hike of $400 for its upcoming redesigned 14-inch and 16-inch MacBook Pro models.
I've spent a good amount of time digging into the spec sheet of the new M6 MacBook Pro (14-inch), and for all intents and purposes, this is a classic Apple "chip and connectivity" refresh. It's not a full redesign. The chassis, Liquid Retina XDR panel, speakers, ports, and battery, all of them carry over unchanged.
However, the M6 brings more cores, stronger on-device AI, higher memory bandwidth on the larger configs, and modern wireless. Here’s the practical rundown of what actually improved, and whether those gains are worth your money.