excel 2013 print preview bottom border missing

The small-screen responsive stuff comes in now. We’re being good little developers and using Plain Ol’ Semantic Markup here for our table. If it is, we’re going to reformat the table. We’re going to use “responsive design” principles (CSS queries) to detect if the screen is smaller than the maximum squishitude of our table. Or you can zoom into the point of readability, but browsing the table will require both vertical and (sad face) horizontal scrolling. So what happens when a screen is narrower than the minimum width of a data table? You can zoom out and see the whole table, but the text size will be too small to read. Responsive design is all about adjusting designs to accommodate screens of different sizes.

Tables can flex in width, but they can only get so narrow before they start wrapping cells contents uncomfortably or just plain can’t get any narrower. A single row of data needs to be kept together to make any sense in a table. Data tables can be quite wide, and necessarily so. Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the 'Applies to' section.In addition to the techniques below, see this roundup of additional explorations of this problem.ĭata tables don’t do so well with responsive design. To work around this problem in Excel 2007, follow these steps:Ĭlick the Microsoft Office Button, click Excel Options, and then click the Advanced tab.Ĭlick to select the Enable fill handle and cell drag-and-drop check box, and then click OK. On the Edit tab, click to select the Allow cell drag and drop check box, and then click OK.

To work around this problem in Microsoft Excel 2000, in Microsoft Excel 2002, and in Microsoft Office Excel 2003, follow these steps: To locate the Enable fill handle and cell drag-and-drop check box, click the Microsoft Office Button, click Excel Options, and then click the Advanced tab.

Note In Microsoft Office Excel 2007, this problem may occur when the Enable fill handle and cell drag-and-drop check box is cleared. This problem may occur when the Allow cell drag and drop check box on the Edit tab of the Options dialog box is cleared. You are not able to drag page breaks in Page Break Preview in Microsoft Excel, although you receive a dialog box indicating that you can.

Excel 2013 print preview bottom border missing