My Table floats around on my desktop. I can't get it to just stay where it is. I can open the same Excel document in a Window's computer, the file (display)doesn't move around on the screen. It is fixed on the screen.
Have looked through all the menus and can't find a direction to keep the Table in one place.
What am i missing?
MacBook Pro 15″, macOS 10.12
When you open the Excel document (or probably any other document) on a Windows computer the document takes over the whole area of your screen. The document's window is in full screen mode. This behavior is often standard on Windows. On the Mac however windows usually do not open in full screen mode. So the window showing your table does not cover the whole screen area but is floating above your desktop and can be moved freely. Is this what you are observing?
Check the window title bar on the Mac. There is a green dot at the very left. Click it and the window goes into full screen mode. Is this what you want? When in full screen mode moving the mouse pointer to the top of the screen and waiting a second will reveal the floating window with the green dot. Click this dot again and you exit out of full screen mode and get the floating window back you startet with.
Hope this helps
When you open the Excel document (or probably any other document) on a Windows computer the document takes over the whole area of your screen. The document's window is in full screen mode. This behavior is often standard on Windows. On the Mac however windows usually do not open in full screen mode. So the window showing your table does not cover the whole screen area but is floating above your desktop and can be moved freely. Is this what you are observing?
Check the window title bar on the Mac. There is a green dot at the very left. Click it and the window goes into full screen mode. Is this what you want? When in full screen mode moving the mouse pointer to the top of the screen and waiting a second will reveal the floating window with the green dot. Click this dot again and you exit out of full screen mode and get the floating window back you startet with.
Hope this helps
Are you opening this Excel document in Excel on your Mac?
Or are you opening an Excel file into Numbers?
If the former, your question should be asked in the Excel support community on the Microsoft website.
If the latter, opening your Excel file with Numbers converts that Excel document to a Numbers document.
In that Numbers document, a Table is an object placed on a Sheet, and moves with respect to the Sheet only if there is a user action that causes the Table to be moved to a different location on the sheet.
The Table may also be moved wrt its position on the screen if there is a user action that results in the Sheet being moved.
Both statements are true for other objects on the sheet: Images and Shapes can be moved on the Sheet, and will be moved on the screen if the Sheet containing those objects is moved.
ALL of these moves require a direct action of the user that moves the object or moves the sheet containing the object, or that changes the size or location of another object which the table is set to maintain distance from.
Missing from your description is any indication of what the user (you) is doing when the Table is moving. Become aware of the actions that are causing the move will move you closer to a solution.
Regards,
Barry
Sheet floats in Excel
